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.



    Rick Krueger

    Follow @dataogre

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply