dtexec error - setting multiple variables

ssis dtexec
Sreedhar picture Sreedhar · Mar 8, 2012 · Viewed 13.7k times · Source

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.

Answer

Sreedhar picture Sreedhar · Mar 8, 2012

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;"\"

Related questions

calling SSIS package with input parameters on stored procedure

I have SSIS packages that is expecting an input parameter ID(integer). I need to execute this SSIS package using stored procedure so that I can pass the value of the ID. DECLARE @Command varchar(1000) , @PackageLocation varchar(1000) , @PackageName varchar(1000) , @XmlID …

Read More
Is it possible to pass parameters to a .dtsx package on the command line?

I am currently executing an SSIS package (package.dtsx) from the command line using Dtexec. This is as simple as: dtexec /f Package.dtsx However, I have some parameters that I would like to pass to the package for it …

Read More
How to pass variable as a parameter in Execute SQL Task SSIS?

I have ssis package in that I'm taking values from flat file and insert it into table. I have taken one Execute SQL Task in that creating one temptable CREATE TABLE [tempdb].dbo.##temptable ( date datetime, companyname nvarchar(50), price decimal(10,0), …

Read More