Hello Every body,
I am using SQLServer 2000 Personal and enterprise edition – VB.net
I already have DTS package with global variable –
Example sourceServerName, sourceUserName, sourcePassword,
TargetServerName ,TargetUserName,TargetPassword.
I need use this package for multiple job scheduling. I don’t want use to
set the design time. I mean dtsrunui.exe because it’s show the all the global
variable and DTS packages.
I am using VB.net … how to do the multiple job schedules in single package …
Please help me

Thanks
Sam


Thanks
Sam

Do you want to call the same package multiple times, but setting different
global variables for each execution. You would create multiple jobs or one
job with several job steps. In the job step, CmdExec command call the
package via dtsrun, and use the /A parameter to configure the global
variables.


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com




"sam" <sam (AT) discussions (DOT) microsoft.com> wrote

Thank you for your Help
Could you tell me , i did one job for one package... how to create multiple
job step with passing global variable... it's so help ful for me
thanks
Sam

"Darren Green" wrote: