Passing path as input parameter

• Papillon-395933

  SSC Veteran

  Points: 293

  More actions

  January 24, 2007 at 2:46 am

  #171181

  Hi

  I have created one SSIS package which extract data from database and put that into verious text files like Emp.txt,Add.txt like that.

  Also I set one globle veriable (CityID) that help in extracting data as citywise.

  When I ran it through command prompt by passing globle veriable to it like

  C:\setup pca\SSIS Packages\SSIS Package File Extract Data\SSIS Package File Extract Data>DTExec /FILE Package.dtsx /SET \Package.Variables[CityID].Value;100

  it gives me data whose CityID is 100 and format it into text files.

  but when i want data for another CityID (101) it overwrites my all previous text files where i kept that files.

  Now my requirment is that i want to set another globle veriable that take PATH as input parameter and place these files in that path location.(How i set this path in command promt and also in SSIS)

  Please guide me

• January 29, 2007 at 8:00 am

  This was removed by the editor as SPAM

• Michael Riedmueller

  SSC-Addicted

  Points: 429

  More actions

  January 30, 2007 at 6:15 am

  #686421

  Hi,

  you can use the same technique to define a variable to hold the path value.

  Inside your SSIS package you need to use an expression for the path property of your data destination.

  You will need to create a new expression and set the property using your variable inside the expression.

  Michael