Dynamically set connection string of SSIS package through cmd

Question

I am trying to dynamically set the connection string of my SSIS package through DTEXEC.exe

My CMD file consists of following command.

"C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTEXEC.exe" /f     
"D:\ABC\XYZ\Packages\ABCD.dtsx" /CHECKPOINTING OFF /REPORTING V /CONSOLELOG/Conn    
"Configurations;'"Data Source=XXXXXX;Initial Catalog=YYYY;Provider=SQLNCLI10.1;Integrated    
Security=SSPI;Auto Translate=False;'"" /SET    
"\Package.Variables[User::TargetEnvironmentId].Properties[Value]";"2"

If i take out connection string part it works fine but when i add

/Conn "Configurations;'"Data Source=XXXXXX;Initial Catalog=YYYY;Provider=SQLNCLI10.1;
Integrated Security=SSPI;Auto Translate=False;'""

This it throws exception and says INVALID

Peter_R · Accepted Answer · 2014-02-04 11:04:29Z

1

Is the name of your connection manager called "Configurations"? I can only assume that is the case. Give the following a try:

/CONNECTION "Configurations";"\"Data Source=XXXX;Initial Catalog=YYYY;Provider=SQLNCLI10.1;Integrated Security=SSPI;Auto Translate=False;\""

I always find it easier to use DTExecUI to create the script, have you tried doing that?

Either that or set the connection string as a variable and pass that through DTExec

answered Feb 4, 2014 at 11:04

Peter_R

6421 gold badge7 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Dynamically set connection string of SSIS package through cmd

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related