Hi DTS Gurus!

How can I export all DTS Packages from a server to another server
(machine) ?

thanks
===========================================
Cristiano Moraes da Silva
SIG Soluções em Informática e Gestão LTDA
Santa Maria - RS - Brasil
cristiano (AT) sigbrasil (DOT) com.br
www.sigbrasil.com.br
+55 552268699

In message <uT#ZNLGZEHA.2456 (AT) TK2MSFTNGP10 (DOT) phx.gbl>, Cristiano Moraes da
Silva <cristiano (AT) sigbrasil (DOT) com.br> writes
Transferring DTS Packages
(http://www.sqldts.com/default.aspx?204)


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Ok, it works......
I imported a system table: sysdtspackages...but no one package is
showed under "Data Transformation Services" folder.

Cristiano.

In message <Oh9dvxGZEHA.3432 (AT) TK2MSFTNGP10 (DOT) phx.gbl>, Cristiano Moraes da
Silva <cristiano (AT) sigbrasil (DOT) com.br> writes
Can you query the destination table sysdtspackages and see what you
expect?

Can you run the msdb stored procedure dbo.sp_enum_dtspackages. Doe you
see what you expect?

Have you refreshed the view in Enterprise Manager?

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org