InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 05:08:11 GMT20http://www.sqlservercentral.com/Forums/Topic576607-364-1.aspxHi, 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 codecd\cd C:\Program Files\Microsoft Office PerformancePoint Server\3.0\BizModelerppscmd stagingdb /operation SynchronizeData /server http://localhost:46787 /path InfoTechOutSourcing.InfoTech_Apps /collection modelsIn that code InfoTechOtSourcing --------->model site NameInfoTech_Apps--------------->Cube Namei can have more than one cube in a model site and more then one model site in an applicationso i want to pass the argument for those 2 values through Execute process taski want my batch file look like thiscd\cd C:\Program Files\Microsoft Office PerformancePoint Server\3.0\BizModelerppscmd stagingdb /operation SynchronizeData /server http://localhost:46787 /path @Arg1.@Arg2 /collection modelsArg1 is Model site Name Arg2 is cubenameEx:@Arg1=InfoTechOtSourcing@Arg2=InfoTech_Appsis that possible?Fri, 26 Sep 2008 03:06:12 GMTanthu_soft