Passing Multiple variables to dtexec in execute process task

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Integration Services » Passing Multiple variables to dtexec in...

Passing Multiple variables to dtexec in execute process task

Rate Topic

Display Mode

Topic Options

Author

Message

sqlbi

Posted Tuesday, March 12, 2013 3:48 PM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 3:03 PM
Points: 31, Visits: 159

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

Rick Krueger

Posted Wednesday, March 13, 2013 12:22 PM

SSC Veteran

Group: General Forum Members
Last Login: Today @ 8:50 AM
Points: 262, Visits: 576

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 »

Permissions