Right Click the Data Transformation Services Folder | ([2000 Open Package]
[ 7 All tasks | Open Package])
Also
Transferring DTS Packages
(http://www.sqldts.com/default.aspx?204)
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Paul" <paul.scotchford (AT) uqconnect (DOT) net> wrote
Quote:
Hi, Forgive my newbieness to DTS, but I have written some
DTS packages on my SQLServer at home and now want to copy
them off there to use at work.
Is there a simple way to do this? I notice that I can save
them to .DTS (structured files) but once I do that how do
I import them into SQLServer at work?
cheers and thanks in advance
Paul |