Windows Server Visual Basic DTS Jobs

By martinbullock15 ·

I'm trying to make a DTS package using VB Script created by the DTS Wizard saved as VB Script.

I have created a DTS Job and saved it like normal to the SQL Server, but i need to have the same DTS job about 12 times with minor changes to package.

I tried to save it as a Visual Basic File which saves the script, i then created a new DTS Package and added a ActiveX Script item and copy and pasted the VB Script that was created by the Wizard into the new package and tried to run the package and it failed. Although i would guess it should be the same as what the normal DTS Package would produce but in VB Script?

Thanks in advance


This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Networks Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums