Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

passing argument to command prompt through Execute Process Task Expand / Collapse
Author
Message
Posted Friday, September 26, 2008 3:06 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 6, 2010 10:54 PM
Points: 12, Visits: 89
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?
Post #576607
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse