Copy DTS to another sql-server

Hey,
How can I copy an DTS to another SQL-server?
I made the dts on a testmachine and want to move it now to the SQL-server on
the production machine.
Thanks
Nic
Hi
Open the Package in DTS Designer and then select "Save As". Save it as
structured storage file.
Copy the file to the new server.
From BOL:
To open a DTS package saved to a structured storage file
In the SQL Server Enterprise Manager console tree, right-click Data
Transformation Services, and then click Open Package.
In the Select File dialog box, click the .dts file you want, and then click
Open.
If multiple Data Transformation Services (DTS) packages or package versions
were saved, the Select Package dialog box appears. Click the package or
package version you want to open.
This is all documented in SQL Server Books Online.
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Nic" <Nic@.discussions.microsoft.com> wrote in message
news:F524682D-55CA-4546-BD06-A14B845FFA81@.microsoft.com...
> Hey,
> How can I copy an DTS to another SQL-server?
> I made the dts on a testmachine and want to move it now to the SQL-server
on
> the production machine.
> Thanks
> Nic
|||Hi,
Alternative approaches.
http://databasejournal.com/features/...le.php/1461521
http://www.sqldts.com/default.aspx?242
Thanks
Hari
SQL Server MVP
"Nic" <Nic@.discussions.microsoft.com> wrote in message
news:F524682D-55CA-4546-BD06-A14B845FFA81@.microsoft.com...
> Hey,
> How can I copy an DTS to another SQL-server?
> I made the dts on a testmachine and want to move it now to the SQL-server
> on
> the production machine.
> Thanks
> Nic