moving a dts package

#11

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

"Allan Mitchell" wrote:

Quote:

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

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.
"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. 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?

"Allan Mitchell" 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 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.

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

moving a dts package

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

Re: moving a dts package - 10-20-2005 , 03:10 PM