hennanra3
asked on
Get Sheetname from Excel Source using SSIS
Hi All,
I have a scenario where I am getting data from an excel source using excel connection manager. From that excel, I want to get the sheet name and load it into database table. Sheet name format is: ABCDEF - 12345678
From that sheet name, I want to get only "12345678" and want to load it into database table, please guide.
Thanks in advance.
I have a scenario where I am getting data from an excel source using excel connection manager. From that excel, I want to get the sheet name and load it into database table. Sheet name format is: ABCDEF - 12345678
From that sheet name, I want to get only "12345678" and want to load it into database table, please guide.
Thanks in advance.
ASKER
I will really appreciate if you can please elaborate in detail about your provided solution as I am a newbie in SSIS.
Thanks
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
string nm = SheetName.Substring(SheetN
Hope it helps.