Dynamic Excel filename
-
I have a Excel sheet as destination.But i need to name that file dynamically from the value from sql query.Can anyone please help.
Actually the excel sheet gets createdin the Foreach loop container. so for each value the excel sheet must be named based on that value coming into the for each loop.Can anyone please help in doing this.
-
rahulabhinav15 (6/3/2014)
I have a Excel sheet as destination.But i need to name that file dynamically from the value from sql query.Can anyone please help.Actually the excel sheet gets createdin the Foreach loop container. so for each value the excel sheet must be named based on that value coming into the for each loop.Can anyone please help in doing this.
Use an expression in the connection manager, with the file name part from a variable.
-
Dynamic file name for Excel Connection Manager – SSIS[/url]
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply