Can SSIS packages call other SSIS packages in the connection string?

0 votes

1 answer

157 views

sql-server-2008 ssis password connection-string

                          I am running an SSIS package that transfers data from one (SQL2008) server to another (SQL2000). However after P2V conversion the SQL2008 server cannot execute an SSIS package due to a user authentication error.

Lets say the package is called "Transfer-Go". In the connection string of that package can it call another SSIS package? In the SSIS library there is another package with the same that appears in the string (called Transfer-Now) name The string is below:

    Data Source=;User ID=;Initial Catalog=;Provider=SQLNCLI10.1;Persist Security Info=True;OLE DB Services=-13;Auto Translate=False;Application Name=SSIS--{8ABA18EE-637E-424F-A3F7-F7E4EA50DD9D};

So is this SSIS package connection string calling that package?

And if the credentials are wrong in that package could that be why I am unable to authenticate?

Thanks for any input, not a DB/SQL guy at all so I apologize if I sound green here.

Asked by mcv110 (75 rep)

Apr 21, 2021, 10:16 PM
Last activity: Apr 21, 2021, 10:37 PM

Can SSIS packages call other SSIS packages in the connection string?

Related Questions