I'm creating a small test package that copies a value from an Excel 2007 worksheet into a SQL 2005 database (SP2). When I do an Execute Task, I get the following error:
SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager \\lorip\MandEScorecards\SQLQueryExample.xlsx failed with error code 0xC0202009.
However, if I do a "Preview" in the Editor for this same Excel Source task that fails, the data comes up as I would expect. What am I missing?
Thanks in advance!
This error code is sometimes related to security issues. How are you running the package?|||
Is this a 64-Bit Server?
If is, there is an Article that show that SQL Server 2005 in 64-Bits don't give support to any OLE DB Transactions especially Excel.
sql
No comments:
Post a Comment