passing argument to command prompt through Execute Process Task

• anthu_soft

  SSC Enthusiast

  Points: 196

  More actions

  September 26, 2008 at 3:06 am

  #194156

  Hi,

  I created the SSIS package. in that package i used Execute process Task transformation in that i give a path for acessing the .bat file. it works fine.

  I have a doubt in passing argument values to batch file through Execute process task.

  I want to explain my problem in detail:

  I have a bath file it run the Command prompt.In my batch file contain the following code

  cd\

  cd C:\Program Files\Microsoft Office PerformancePoint Server\3.0\BizModeler

  ppscmd stagingdb /operation SynchronizeData /server http://localhost:46787 /path InfoTechOutSourcing.InfoTech_Apps /collection models

  In that code

  InfoTechOtSourcing --------->model site Name

  InfoTech_Apps--------------->Cube Name

  i can have more than one cube in a model site and more then one model site in an application

  so i want to pass the argument for those 2 values through Execute process task

  i want my batch file look like this

  cd\

  cd C:\Program Files\Microsoft Office PerformancePoint Server\3.0\BizModeler

  ppscmd stagingdb /operation SynchronizeData /server http://localhost:46787 /path @Arg1.@Arg2 /collection models

  Arg1 is Model site Name

  Arg2 is cubename

  Ex:

  @Arg1=InfoTechOtSourcing

  @Arg2=InfoTech_Apps

  is that possible?