Escape character for SSIS command line parameters

  • Article

 

You basically have to wrap everything within quotes by basically escaping the quote(") as in this example:

 

/SQL "TestPkg" /SERVER TestServer /MAXCONCURRENT " -1 " /CHECKPOINTING OFF  /SET "\Package.Variables[User::MetaDataConnectionString].Value";"\"Data Source=TestServer;Initial Catalog=TestDB;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;\""