Re: Saving DTS

#1

Try this-

http://www.sqldev.net/dts/SavePkgToFile.htm

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

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

Quote:

Does anyone know of a way of emulating the save to COM
Structured File method that creates a valid .dts file, but
DOES NOT CHANGE THE GUID OR THE CONTENTS.

I have tried extracting the binary image information from
sysdtspackages and streaming this to a file as bytes, but
I don't think that the .dts format is just a dump of this
field of the sysdtspackages table, is it? It won't load, I
know that.

I am trying to automate scripting into VSS with change
information every time. However the very act of saving
into VSS means that the file has changed.
Adding a binary file night after night into VSS is going
to hit it pretty hard.

Any thoughts anyone?

#2

I have battled with textcopy, but no win. I cannot get it
to run under NT Auth (trusted connections)

Various sites have indicated that no username or password
specified will let this happen, but I still get prompted
for both. This is no good for running as a job.
Some sites also indicate that using it to connect to
sql2000 you need to set up a server alias to connect via.
Tried this. No luck.

ANyone any ideas?

Quote:

-----Original Message-----
Try this-

http://www.sqldev.net/dts/SavePkgToFile.htm

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

"Adrian Hall" <adrian.hall (AT) npower (DOT) com> wrote in message
news:0d4b01c34ae4$b714f9f0$a401280a (AT) phx (DOT) gbl...
Does anyone know of a way of emulating the save to COM
Structured File method that creates a valid .dts file,
but
DOES NOT CHANGE THE GUID OR THE CONTENTS.

I have tried extracting the binary image information
from
sysdtspackages and streaming this to a file as bytes,
but
I don't think that the .dts format is just a dump of
this
field of the sysdtspackages table, is it? It won't
load, I
know that.

I am trying to automate scripting into VSS with change
information every time. However the very act of saving
into VSS means that the file has changed.
Adding a binary file night after night into VSS is going
to hit it pretty hard.

Any thoughts anyone?

.

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

Re: Saving DTS

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

Re: Saving DTS - 07-16-2003 , 03:18 AM

Re: Saving DTS - 07-16-2003 , 05:27 AM