SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER
-
Hi Experts, I have a package to import data from Excel to SQL tables. I have created and depolyed the package on production server say "ProdServer". Also I have created job on the same server and it runinng the package successfully. Even I run it manually it is running properly. But problem here is when I am connecting to SQL installed on the production server from my local machine using windows authentication and trying to run the package manually it gives below error. Executed as user: SERVERNAME\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 7:41:10 AM Error: 2014-07-15 07:41:17.24 Code: 0xC0202009 Source: ImportMasterData Connection manager "PracticeMapping" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. End Error Error: 2014-07-15 07:41:17.27 Code: 0xC020801C Source: Load Practice Get Practice [69] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "PracticeMapping" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2014-07-15 07:41:17.29 Code: 0xC004701A Source: Load Practice SSIS.Pipeline Description: component "Get Practice" (69) failed the pre-execute phase and returned error code 0xC020801C. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 7:41:10 AM Finished: 7:41:17 AM Elapsed: 6.692 seconds. The package execution failed. The step failed So in short when I run the packgae direclty from production server it works fine but from local machine or any other machine by connecting to the SSMS and running manually, it get failed. Please help me guys on this issue. Its very very urgent. Thanks and Best Regards, Mangesh
-
Hi Experts, I have a package to import data from Excel to SQL tables. I have created and depolyed the package on production server say "ProdServer". Also I have created job on the same server and it runinng the package successfully. Even I run it manually it is running properly. But problem here is when I am connecting to SQL installed on the production server from my local machine using windows authentication and trying to run the package manually it gives below error. Executed as user: SERVERNAME\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 7:41:10 AM Error: 2014-07-15 07:41:17.24 Code: 0xC0202009 Source: ImportMasterData Connection manager "PracticeMapping" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. End Error Error: 2014-07-15 07:41:17.27 Code: 0xC020801C Source: Load Practice Get Practice [69] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "PracticeMapping" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2014-07-15 07:41:17.29 Code: 0xC004701A Source: Load Practice SSIS.Pipeline Description: component "Get Practice" (69) failed the pre-execute phase and returned error code 0xC020801C. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 7:41:10 AM Finished: 7:41:17 AM Elapsed: 6.692 seconds. The package execution failed. The step failed So in short when I run the packgae direclty from production server it works fine but from local machine or any other machine by connecting to the SSMS and running manually, it get failed. Please help me guys on this issue. Its very very urgent. Thanks and Best Regards, Mangesh
-
Hi Experts, I have a package to import data from Excel to SQL tables. I have created and depolyed the package on production server say "ProdServer". Also I have created job on the same server and it runinng the package successfully. Even I run it manually it is running properly. But problem here is when I am connecting to SQL installed on the production server from my local machine using windows authentication and trying to run the package manually it gives below error. Executed as user: SERVERNAME\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 7:41:10 AM Error: 2014-07-15 07:41:17.24 Code: 0xC0202009 Source: ImportMasterData Connection manager "PracticeMapping" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. End Error Error: 2014-07-15 07:41:17.27 Code: 0xC020801C Source: Load Practice Get Practice [69] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "PracticeMapping" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2014-07-15 07:41:17.29 Code: 0xC004701A Source: Load Practice SSIS.Pipeline Description: component "Get Practice" (69) failed the pre-execute phase and returned error code 0xC020801C. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 7:41:10 AM Finished: 7:41:17 AM Elapsed: 6.692 seconds. The package execution failed. The step failed So in short when I run the packgae direclty from production server it works fine but from local machine or any other machine by connecting to the SSMS and running manually, it get failed. Please help me guys on this issue. Its very very urgent. Thanks and Best Regards, Mangesh
On which system did you develop the package? Is the connection manager set to use "localhost"?
You'll never get very far if all you do is follow instructions.