Question Locked

Windows Server Visual Basic DTS Jobs

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi

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

Martin

1 reply

This discussion is closed to new replies.