Steve Conklin
developer at ultradnt.com
Thu Jul 13 09:38:47 CDT 2006
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