Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Passing Multiple variables to dtexec in execute process task Expand / Collapse
Author
Message
Posted Tuesday, March 12, 2013 3:48 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 2, 2014 7:37 AM
Points: 31, Visits: 197
Hi,

how to pass multiple variables to dtexec in execute process task.

it is working fine when i pass one variable for example

/f "C:\Users\mydir\Documents\SRM_IS\IS\ETL\RMG.Imp.FlatFile_Format1.dtsx" /SET "\Package.Variables[User::SrcDataPath].Properties[Value]";"C:\Users\mydir\Documents\FlatFiles\Myfiles"


when i want to pass multiple variables it is throwing syntax error for dtexec

/f "C:\Users\mydir\Documents\SRM_IS\IS\ETL\RMG.Imp.FlatFile_Format1.dtsx" /SET "\Package.Variables[User::SrcDataPath].Properties[Value]";"C:\Users\mydir\Documents\FlatFiles\Myfiles"/SET "\Package.Variables[User::vRootDir].Properties[Value]"; "C:\Users\mydir\Documents\SRM_IS\IS\ETL\"

is there any work for passing the variables.
Post #1430128
Posted Wednesday, March 13, 2013 12:22 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 5:24 PM
Points: 262, Visits: 681
Just eyeballing that string, two things that I would try:
1. put a space before the 2nd /SET
2. lose the trailing \ in "C:\Users\mydir\Documents\SRM_IS\IS\ETL\". I seem to recall seeing DTEXEC having problems with the trailing slash.




Rick Krueger

Follow @dataogre
Post #1430567
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse