[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...