June 13, 2011 at 6:30 am
Hi,
i hav a pkg which need to load excel sheets to db table.my pkg works fine when i ran it first time.but then it gives following error .i used a for each loop to get all excel files with in that used a script task under that a data flow task.i get the error at data flow task (excel source)...any help ?? will be greatly appreciated..
TITLE: Microsoft Visual Studio
------------------------------
Error at Package [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 Office Access Database Engine" Hresult: 0x80004005 Description: "The Microsoft Office Access database engine cannot open or write to the file 'C:\Documents and Settings\m.devendar\Desktop\New Folder'. It is already opened exclusively by another user, or you need permission to view and write its data.".
Error at Load xl sheets [Excel Source [1]]: 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
------------------------------
June 13, 2011 at 6:33 am
devender.07042 (6/13/2011)
i hav a pkg which need to load excel sheets to db table.my pkg works fine when i ran it first time.but then it gives following error .i used a for each loop to get all excel files with in that used a script task under that a data flow task.i get the error at data flow task (excel source)...any help ?? will be greatly appreciated..
TITLE: Microsoft Visual Studio
------------------------------
Error at Package [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 Office Access Database Engine" Hresult: 0x80004005 Description: "The Microsoft Office Access database engine cannot open or write to the file 'C:\Documents and Settings\m.devendar\Desktop\New Folder'. It is already opened exclusively by another user, or you need permission to view and write its data.".
Error at Load xl sheets [Excel Source [1]]: 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
------------------------------
please help .........i am going nuts ...............
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply