March 21, 2017 at 5:58 pm
I am trying to upload excel file to database using SSIS Data flow. I have excel connection that points to excel file but when I try to configure excel data source, I keep getting error. Please help.
I can see sheet name in "Name of the Excel Sheet" drop down, after selecting it, when I click on "Columns", I get following error:
TITLE: Microsoft Visual Studio
------------------------------
Exception from HRESULT: 0xC02020E8
Error at <data flow task name> [<excel connection name> [14]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
Error at <data flow task name> [<excel connection name> [14]]: Opening a rowset for "<sheet name>" failed. Check that the object exists in the database.
Sheet name is in following format:
ABCDE_F111_G111_H111_J111_K11_T$
------------------------------
BUTTONS:
OK
------------------------------
-- Harpreet
March 22, 2017 at 1:18 am
The source excel you are using is it created dynamically? Or it is already there in system and you are just selecting it in SSDT while development.
March 22, 2017 at 8:23 am
Excel file is already there.
Thanks,
Harpreet
March 28, 2017 at 3:28 pm
So far it seems like its length of characters in sheet name. Even though sheet name is 31 chars long (excluding trailing $ sign), SSIS doesn't pick it up every time.
Assuming that inclusion of '$' in sheet name makes it 32 chars long, may be failing because of that.
Anyone else have such problem or have found out a solution to use such excel files with 31 char sheet name, please advise.
Thanks,
Harpreet
March 29, 2017 at 1:31 pm
hskhakh - Tuesday, March 28, 2017 3:28 PMSo far it seems like its length of characters in sheet name. Even though sheet name is 31 chars long (excluding trailing $ sign), SSIS doesn't pick it up every time.Assuming that inclusion of '$' in sheet name makes it 32 chars long, may be failing because of that.
Anyone else have such problem or have found out a solution to use such excel files with 31 char sheet name, please advise.
Thanks,
Harpreet
As there's no way around it, you'll have to get the sheet renamed some other way. You might be able to use a Script Task and VB to use the Excel Object Model and see if that will allow the sheet to be renamed... You'll have to be sure the new name doesn't conflict with any other sheet names though.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply