[dba-SQLServer] Exporting from SQL 2000 to SQL 2003

You could export the DTS jobs to files,  which I have done to move them from
one 2000 server to another (its in the job designer screen in EM). However,
how they import into 2005 I couldn't say.

Hth
Steve

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Francisco
Tapia
Sent: Thursday, July 13, 2006 4:19 AM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] Exporting from SQL 2000 to SQL 2003

DTS packages live in the MSDB database, you may have some luck using a tool
like DTS 2000 backup. (google)



On 7/12/06, Jim Lawrence <accessd at shaw.ca> wrote:
>
> Hi All:
>
> Here is a simple question? I have recently exported a database from a 
> SQL 2000 server to a SQL 2003 server and everything went through with 
> minimal problems with exception to DTS packages. They just did not import.
>
> I was wondering if DTS packages have to be re-created, there is a 
> simple solution or there is some trick to importing them.
>
> MTIA
> Jim
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>


--
-Francisco
http://pcthis.blogspot.com |PC news with out the jargon!
http://sqlthis.blogspot.com | Tsql and More...
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com