June 3, 2014 at 1:06 pm
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.
June 3, 2014 at 1:08 pm
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.
😎
June 3, 2014 at 1:12 pm
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
June 3, 2014 at 1:15 pm
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply