Dynamic Xlsx files

[Mohammed Nawaz]

Hey,
Is there a way to create dynamic xlsx files using excel destination
plus. I want to be able to extract data from a sql table on a daily
basis and export into excel file with a currentdate as part of the
excel file. Please Advise.

thanks.

[Ivan Peev]

Hi Mohammed,

You can setup empty excel workbook , which you will copy into the destination excel file you want created and then you can populate this empty excel file using either the standard Excel Destination component or COZYROC's Excel Destination Plus component.

Ivan

[Ivan Peev]

Mohammed,

Prior to the data flow task you should have File Task, which copies your empty template excel file to the destination excel file. THe destination file name will be dynamically setup using expressions based on the current day, month, etc. Then you will use a data flow task to populate the destination excel file with the information you need.

On Monday, July 9, 2012 5:32:39 PM UTC-4, (unknown) wrote:

Ivan,

 

Can i change the name of the file each time it runs. I created the variable and assigned the expression to add teh day/month/year of the current date and then assigned that variable as an expression to the excel connection manager. But it would still not create a new file and keeps updating the default file name i as configured with.

 

Thanks.