DTS packages in SQL 2005

27 Jan 2006 10:34 PM

John Holmes

I see them show up under a node called Legacy in Management Studio. What is
the plan for migration of DTS packages from 2000 to 2005? We have lots of
these that we'll need to migrate that are in use with various SQL jobs.

Thanks,

John

28 Jan 2006 2:10 AM

Jéjé

there is a migration wizard to help you.
but you'll have a lot of manual job to do to really convert DTS to SSIS. (to
make sure that the upgrade is correct and to use the new features)

but you can continue to execute your DTS packages in 2005.

Show quoteHide quote

"John Holmes" <joh***@co.skagit.wa.us> wrote in message
news:efrhJH5IGHA.140@TK2MSFTNGP12.phx.gbl...
>I see them show up under a node called Legacy in Management Studio. What is
>the plan for migration of DTS packages from 2000 to 2005? We have lots of
>these that we'll need to migrate that are in use with various SQL jobs.
>
> Thanks,
>
> John
>

27 Feb 2006 11:06 PM

Ximena Cardenas

Have you found any documentation about what kind of code or task need manual
job to be migrated? Or should I learn it on the field, one by one??

Show quoteHide quote

"JÃ©jÃ©" wrote:

> there is a migration wizard to help you.
> but you'll have a lot of manual job to do to really convert DTS to SSIS. (to
> make sure that the upgrade is correct and to use the new features)
>
> but you can continue to execute your DTS packages in 2005.
>
> "John Holmes" <joh***@co.skagit.wa.us> wrote in message
> news:efrhJH5IGHA.140@TK2MSFTNGP12.phx.gbl...
> >I see them show up under a node called Legacy in Management Studio. What is
> >the plan for migration of DTS packages from 2000 to 2005? We have lots of
> >these that we'll need to migrate that are in use with various SQL jobs.
> >
> > Thanks,
> >
> > John
> >
>
>
>