Execute Process Task
Hi, Is the dynamic assignment of batchfile name in Execute Process task is possible. For Example i have to assign the batch file name whenever the packages starts running but not hard coded. I have used the config file for the Destination manager connection which works fine, I just wanted to know is it possible to use .config file even for Execute Process taskRegards, Santhosh Hiriyanna
October 26th, 2010 8:07am

Yes you can add a package config for an [Execute Process Task] the same way you do for the [Connection Manager] You can then just choose the properties that need to be configured.
Free Windows Admin Tool Kit Click here and download it now
October 26th, 2010 8:25am

Can u please explain me how to set that connections bcoz i am finding very difficult to set those vaues or set the property.Regards, Santhosh Hiriyanna
October 26th, 2010 8:28am

Are you talking about the actual path to the batch file
Free Windows Admin Tool Kit Click here and download it now
October 26th, 2010 8:37am

Yes , I have used Execute Package task which calls the child package ...... so whenever the child package is called the dynamic assignemt of the bat file shoul be done.......Regards, Santhosh Hiriyanna
October 26th, 2010 8:41am

Ok so do you want to put the path of the batch file into a .dtsConfig file? Will this path change everytime the package runs?
Free Windows Admin Tool Kit Click here and download it now
October 26th, 2010 8:46am

Directory would remain the same but the name the batch file changes every time whenever the child package is calledRegards, Santhosh Hiriyanna
October 26th, 2010 8:50am

Are you willing to change the path in the .dtsConfig file everytime? If so, you can just go to 'package configurations' Add a new configuration Then choose the file or create a new file. Then go to the executable [Execute Process Task] name and select the properties you wanna configure. You will see there will be a 'Executable' property. This is the path that you want to configure.
Free Windows Admin Tool Kit Click here and download it now
October 26th, 2010 8:55am

Ya my problem starts while changing the file name bcoz the files ll be thr within the folder so whenever the child package is called the bat file must be set respective batch fileRegards, Santhosh Hiriyanna
October 26th, 2010 9:04am

You could maybe use a [for each container] to loop through the specified folder and store the name of the batch file in a package variable.
Free Windows Admin Tool Kit Click here and download it now
October 27th, 2010 6:42pm

Hi , Thank u so much....its working fine now...Thanks once againRegards, Santhosh Hiriyanna
October 28th, 2010 3:31am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics