Click here to Skip to main content
15,945,603 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:

I have a SQL data source and my destination is Excel in SSIS.
I want my Excel Destination to be created dynamic at run time based on Current date.
It's possible if destination is a text file by setting Connection string property but the same is not working when destination is Excel.

Arvind Jha
Mohibur Rashid 29-Jan-16 4:38am    
and what would be the relevant code?
Arvind Jha 29-Jan-16 6:29am    
Can it be not done in SSIS only through Expressions?

1 solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900