Is there a simple way to Copy SQL Server 2000 DTS package and deploy it in another server?

sql-server dts
Elias Haileselassie picture Elias Haileselassie · Jun 9, 2009 · Viewed 8.3k times · Source

I am trying to copy a database from one server to another in id different location, including all the schema, data, DTS Package and Scheduled Jobs. I used Redgates SQL Packager to pack the schema and data.But I am having trouble in packing the DTS Package (which is a very complex one) in simpler way.Please advice!

Answer

Paulo Santos picture Paulo Santos · Jun 9, 2009

I don't have an SQL2000 at hand right now, but I remember that you can simply open the DTS, click File \ Save As... and then save as an DTS file and that would be able to upload the DTS on another server.

Related questions

How to create an SQL table and and populate it with Excel spreadsheet data?

Is there an easy way to create a table in SQL Server (2005) from an Excel spreadsheet. I'm thinking maybe some tool? Thanks in advance.

Read More
DTS_E_OLEDBERROR. Error code: 0x80004005.Difference between SQl Native client and oledb provider for sql server

There was a communication link error while I was using SQL Server Native Client 10 in an SSIS Data Flow component. Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record …

Read More
SSIS Transfer Database task cryptic error message 0x80131500

I am using SSIS with VS2010 (shell) and databases going from SQL Server 2005 (32 bit)to SQL Server 2012 (64 bit). I am developing directly on the destination server (not optimal, but it works). When I try to use the Transfer database task, …

Read More