Passing Multiple variables to dtexec in execute process task
-
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.
-
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.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply