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