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.
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
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?
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.
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.
October 27th, 2010 6:42pm
Hi , Thank u so much....its working fine now...Thanks once againRegards, Santhosh Hiriyanna
October 28th, 2010 3:31am