September 26, 2008 at 3:06 am
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?
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply