December 1, 2009 at 12:49 pm
Hello,
I am Rahul, and my problem is I need to export data from excel to sql server but before that i need to access(import) the data from the webservice and save it into excel, so when i take a copy of the excel from the website and try to export it into sql server i get following error messages at the EXCEL source
"Error: 0xC020801C at Data Flow Task, Excel Source [375]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Error: 0xC0047017 at Data Flow Task, SSIS.Pipeline: component "Excel Source" (375) failed validation and returned error code 0xC020801C.
Error: 0xC004700C at Data Flow Task, SSIS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at Data Flow Task: There were errors during task validation."
But if i open the copy of the excel sheets on my local machine it works can some one help me out with this...
Thanks
December 1, 2009 at 3:02 pm
Do you happen to have the spreadsheet open in Excel at the same time. I have seen that cause trouble..
CEWII
December 1, 2009 at 3:06 pm
yes i do but as soon as i close the spreadsheet it doesn't work
December 1, 2009 at 3:22 pm
Ok, so you have a file that is in excel as an XLS file, not CSV or something goofy like that. IT is a realy XLS file?
Are you able to select the sheet and see the fields in the source connector?
CEWII
December 1, 2009 at 3:32 pm
It is a .xls file but the i cant preview the data if the spreadsheet is closed I get an error saying "external table is not in format"
TITLE: Microsoft Visual Studio
------------------------------
Error at Arg_Currency [Connection manager "Excel Connection Manager"]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "External table is not in the expected format.".
Error at Data Flow Task [Excel Source [375]]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
------------------------------
ADDITIONAL INFORMATION:
Exception from HRESULT: 0xC020801C (Microsoft.SqlServer.DTSPipelineWrap)
------------------------------
BUTTONS:
OK
------------------------------
Thanks a lot for the reply...
December 1, 2009 at 3:44 pm
XLS or XLSX? What version of excel are you using..
CEWII
December 1, 2009 at 5:56 pm
I'm using excel 2003 i.e. xsl
December 2, 2009 at 8:11 am
I was doing a search on your error and found this forum post http://forums.asp.net/t/993765.aspx. I'd see if that helps..
CEWII
December 2, 2009 at 8:27 am
Thanks a lot
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply