Re: Scripting DTS jobs to VSS.

#1

There is no Save As VB option on the object model. The closest you could get
would to write the script yourself. You can enumerate all objects and
properties via the object model so you have the information. For a good
start have a look at the ScriptPkg demo project that shipped with SQL Server
7.0. On the CD under samples\dts expand dtsdemo.exe.

--
Darren Green
http://www.sqldts.com

"Adrian Hall" <adrian.hall (AT) npower (DOT) com> wrote

Quote:

I am trying to add DTS scripting to my current database
scripting into VSS

I can't seem to find a way of automating the saving of a
DTS package to a .bas file

Saving to a .dts is not really an option as this is not
very VSS friendly - can't compare files. And it will be a
nightly job, so the changed binaries will mount up
quickly.

The option isn't provided as one of the DTSPAckage object
methods. anyone know why not?

TIA.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Scripting DTS jobs to VSS.

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Scripting DTS jobs to VSS. - 07-14-2003 , 09:02 AM