Dtexec error - setting multiple variables

I am trying to execute an SSIS package using the dtexec command line utility.

my syntax for dtexec is as follows:

dtexec /FILE "C:\DirectLoads\RefEDWDirectLoads.dtsx" /Set \Package.Variables [User::SourceDirectory].Properties[Value];"C\Test" /Set \Package.Variables [User::EDWConnection].Properties[Value];"Data Source=hts0476;Initial Catalog=EDW;Provider=SQLNCLI10.1;Integrated Security=SSPI;" 

when executing its throwing error:

 Argument ""\Package.Variables[User::EDWConnection].Properties[Value];Data Source=hts0476;Initial Catalog=EDW;Provider=SQLNCLI10.1;Integrated Security=SSPI;"" for option "set" is not valid. 
+7
source share
1 answer

Yes, this is fixed as

 dtexec /FILE "C:\DirectLoads\RefEDWDirectLoads.dtsx" /Set \Package.Variables [User::SourceDirectory].Properties[Value];"C\Test" /Set \Package.Variables [User::EDWConnection].Properties[Value];\""Data Source=hts0476;Initial Catalog=EDW;Provider=SQLNCLI10.1;Integrated Security=SSPI;"\" 
+13
source

All Articles