Hi I have a dts package that connects to an oracle database and an MSSQL
database and moves some data from the MSSQL dbase to the Oracle dbase.
I need to move the package to a different server that is not connected via a
network. Just wondering if the dts package can be copied onto media (like a
file) and if so how?
Thanks.--
Paul G
Software engineer.

Save the file as a structured storage file

http://sqlservercode.blogspot.com/



"Paul" wrote:

ok thanks for the information.
--
Paul G
Software engineer.


"SQL" wrote:

Hello Paul,

You could save it as a Structured storage file or you can even export the
contents of msdb.dbo.sysdtspackages to a text file and take that to the other
PC. You could also save as a VB .bas file.



Allan

Hi thanks for the information. Just wondering how to save this in these
different formats? The package shows up in enterprise manager and is this
where I can save it? How do you export the contents and save it to a text
file?
--
Paul G
Software engineer.


"Allan Mitchell" wrote:

Hello Paul,

You could export using a DTS package. You will not see the table pop up
in the designer dropdown so you will need to use a query and say

SELECT * FROM dbo.sysdtspackages.


The SSF and VB.bas file then you can se "Save As"


Allan

Hi thanks for the information. So from query analyzer would I just use
something like

SELECT * FROM dbo.sysdtspackages.
Save AS newfilename.dts
and just run this from the master dbase.


--
Paul G
Software engineer.


"Allan Mitchell" wrote:

Open up the package
go to Package/Save as, select SSF from the location, give it a name and save
it

http://sqlservercode.blogspot.com/


"Paul" wrote:

ok thanks was able to save it.
--
Paul G
Software engineer.


"SQL" wrote:

Hello Paul,

No.

You could use a DTS package to do the export to text file and then import
it back using dts into msdb.dbo.sysdtspackages.

Allan