Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

dtexec error - setting multiple variables

Tags:

ssis

dtexec

Am trying to execute SSIS package with 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 executed 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.
like image 697
Sreedhar Avatar asked Mar 08 '12 03:03

Sreedhar


1 Answers

Yes got this 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;"\"
like image 131
Sreedhar Avatar answered Oct 02 '22 23:10

Sreedhar