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.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums