August 23, 2011 at 6:43 am
Hi Guys
I have a package that imports data from multiple text files in a folder and inserts them into an excel file. Problem is that all the text files are sent to 1 sheet.
Is there a way that i could send each text file to a seperate sheet? and have that sheet name the same as the Filename?
Thanks
Jameel
August 24, 2011 at 12:11 am
so nobody can help??
August 24, 2011 at 8:21 am
I recall creating a @[User::SheetName variable to store the Current Worksheet.
Create a script task to set the value of the @[User::SheetName variable.
In the Excel Destination Component, Change the data access mode to ‘Table Name or View Name Variable’ and choose @[User::SheetName) from the variable dropdown list.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 25, 2011 at 2:05 am
Thanks! that helped alot, problem sorted 😀
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply