Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
santoshini_mohini
Starting Member
5 Posts |
 Posted - 2009-01-21 : 23:49:26
|
| I am trying to export data into excel file using Excel destination. In the Connection manager when i try to provide static Excel File path then it works fine. But when i provide dynamic Excel path i am getting the following error "Error at Data flow task[Excel Destination[1480]];Opening a rowset for "Excel Destination" failed.Check that the object exists in the databse."I followed the below things to create dynamic excel destination(DelayValidation property of package and Excel destination , both are true.)1.I created a variable "XLFileRootDir" and assigned an expression - "D:/CDO/SSIS/"+"ExcelTarget" + (DT_WSTR,4)DATEPART("yyyy",GETDATE()) + "-" + (DT_WSTR,2)Datepart("mi",getdate()) + "-" + (DT_WSTR,2) Datepart("ss",getdate()) + ".xls"2.Then in the Excel connection manager i assigned "XLFileRootDir" variable to ExcelFilePath property.3.In Excel destination , i choosed data access mode as "Table or view" and created a new work sheet by cliking on New button. The worksheet created successfully.But when i try to go to Mapping Tab or click on Preview button i use to get the same error.Plz help on thisSantoshini |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-22 : 08:43:29
|
| You need this:http://www.sqlnerd.com/ssis_dynamic_dates.htm |
 |
|
|
santoshini_mohini
Starting Member
5 Posts |
Posted - 2009-01-23 : 07:56:05
|
| Thanx for replying ..In that bolg , the varibale which contains dynamic path is assigned to ConnectionString property which not accepatble in case of Excel. Here in my case i have assigned the same varible to ExcelFile path property. And the same is being used in Data source attribute inside ConnectionString Property .. Thats the prob..Santoshini |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-23 : 09:57:16
|
| why are you using same variable for path and connectionstring ? didnt get that |
|
|
|
santoshini_mohini
Starting Member
5 Posts |
Posted - 2009-01-27 : 04:27:59
|
| My ConnString will have something like this:Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:/CDO/SSIS/ExcelTarget-2009-1-27.xls;Extended Properties="EXCEL 8.0;HDR=YES";And My ExcelPath property will contain "D:/CDO/SSIS/ExcelTarget-2009-1-27.xls" where i would have assigned my variable.Santoshini |
|
|
|
lugdug
Starting Member
1 Post |
Posted - 2009-12-25 : 13:57:23
|
| Hello, did you solve your problem ("Error at Data flow task[Excel Destination[1480]];Opening a rowset for "Excel Destination" failed.Check that the object exists in the databse.)? I have same problem ...Can you help me ? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-02 : 03:36:43
|
| can you try this?http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/ab529613-fc43-4ab1-847f-098c082f3b7e/ |
|
|
|
|
|
|
Dynamic Excel destination