Windows Server Visual Basic DTS Jobs - TechRepublic
Question
June 9, 2009 at 02:59 PM
martinbullock15

Windows Server Visual Basic DTS Jobs

by martinbullock15 . Updated 17 years, 1 month ago

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

This discussion is locked

All Comments