I am trying to import excel file and load it into sql sever database and i have created dynamic folder path and the file name as dynamic but my only issue is that i am not able to create dynamic sheet names. Users can put a new excel file with different sheet name each time they update the file so i am trying to find out either a way to rename the excel sheet or use the sheet name as variable. I have goggled online but i don't see step by step instruction and i get error every time i try to follow their instruction. In the excel file, it is always one sheet only. Thanks.
Asked
Active
Viewed 2,125 times
0
-
Can you give an example of an error you got, and what you were trying when you got it? – Tab Alleman Oct 14 '14 at 17:24
-
Check out [OpenRowset from variable](http://www.sqlservercentral.com/Forums/Topic637794-148-1.aspx). Someone has answered similar question. – Tak Oct 14 '14 at 18:15
-
i checked the link but did not help me, i don't have multiple sheets in my excel file but it is only one sheet. thanks – moe Oct 14 '14 at 18:28
-
Cant you create a process that would open the excel and rename the sheet? This is out of SSIS Scope IMO, but doable via an external script. – rvphx Oct 15 '14 at 22:50
-
Did you try script task or script component – Govind Dec 30 '14 at 07:48