CODEWITHSUNDEEP
ssis
Renugopal
Renugopal

Reputation: 33

Failed to load the package

I have two sql servers SQL1 and SQL2 and i added few packages to SQL1. Lets say SQL1 has a pacakage called P1 and it has a child package called C1. package P1 has a connection manager called MyConn which is pointing to SQL2. Now the connection property of a child package set with MyConn connection manager. If I try to execute package P1 it says following error.

Description: Error 0xC001000A. Failed to load the package "C1" from SQL Server "SQL2". Make sure that the package exists on the instance of SQL Server and that you have the correct credentials to access it.

But my packages are existing in SQL1 only. But why it is trying to connect it from SQL2 ?

Upvotes: 2

Views: 1422

Answers (1)

Joe S
Joe S

Reputation: 346

You said the child package is set to the MyConn connection manager, which is pointing to SQL2. However, you also mentioned that both packages exist on SQL1. You cannot use the MyConn connection for the child package since that is the wrong SQL Server.

You will need to create another SQL Connection Manager that points to SQL1 and add that to the Execute Package Task like the screenshot below (this is assuming you are using "External Reference" in the ReferenceType property, which based on your question, it sounds like you are using).

enter image description here

Upvotes: 1

Related Questions