SQL 2000 to SQL 2008 DTS/SSIS questions

We are currently planing on migrating from SQL server 2000 to SQL Server 2008.
I have read that DTS packages will work in SQL Server 2005 but I can not
find anywhere if they will work in 2008? Or do we have to convert all of our
DTS to SSIS?

I have also read there is a tool - Microsoft SQL server DTS Designer
components that allows the user to edit and create new DTS packages in SQL
server 2005. If DTS can run in SQL Server 2008, is there a similar tool that
can be used to edit/add DTS packages in SQL Server 2008?

Is there any reading material out there for this scenario (SS 2000 to SS
2008 DTS to SSIS). What is the suggested approach?

Thanks
Tsharp

Toni,

DTS is still available at SQL Server 2000 level for SQL Server 2008, but not
enthusiastically supported.
http://msdn.microsoft.com/en-us/library/cc707786.aspx

There are a few steps to go through, but (at least on SQL Server 2005) it
all works just fine. Therefore, it is still being supported for 2008, and
the documentation on how to do it is a bit better than the 2005 docs.

RLF


"Toni" wrote in message

> We are currently planing on migrating from SQL server 2000 to SQL Server
> 2008.
> I have read that DTS packages will work in SQL Server 2005 but I can not
> find anywhere if they will work in 2008? Or do we have to convert all of
> our
> DTS to SSIS?
>
> I have also read there is a tool - Microsoft SQL server DTS Designer
> components that allows the user to edit and create new DTS packages in SQL
> server 2005. If DTS can run in SQL Server 2008, is there a similar tool
> that
> can be used to edit/add DTS packages in SQL Server 2008?
>
> Is there any reading material out there for this scenario (SS 2000 to SS
> 2008 DTS to SSIS). What is the suggested approach?
>
> Thanks
> Tsharp
>