May 25, 2011 at 1:32 am
Hi everyone, Im getting an error when I try to make my OLE DB Destination(for Excel 207) dynamic by using a variable to provide the connection string under expressions. In the connection string the filename im trying to achieve is like FileName_20110524.xlsx
This fails when the package runs I was able to use this approach to create .txt file destinations dynamically but not with .xlsx files.
One approach i know is by creating a template .xlsx file and using it to create a file for each run of the package but i am looking to accomplish this dynamically. Please let me know if this is possible and how to achieve it?
Thank you.
May 25, 2011 at 2:17 am
An easy way round that is to use the same file name every time as the destination, but to have a FST afterwards to copy it wherever you want.
The template idea is the easiest to implement, even if it's completely empty.
I don't think SSIS can create xslx files natively. You could always install Excel on the server and then use a script task to instantiate an Excel application object - from there you can do almost anything you can think of in Excel via code.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
May 25, 2011 at 11:31 am
Even if I create a new file each time using the template and file system task can the OLEDB Destination be dynamic enough to point to this newly created destination? does anyone know if this is supported??
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply