passing argument to command prompt through 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 argument to command prompt through...

passing argument to command prompt through Execute Process Task

Rate Topic

Display Mode

Topic Options

Author

Message

anthu_soft

Posted Friday, September 26, 2008 3:06 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, May 06, 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 »

Permissions