Archive for February, 2009

Is DTS Dead?

Wednesday, February 25th, 2009

IS DTS dead?

No.

The reasons:

The huge installed base of Sql Server 2000, some of which may never be upgraded.
The huge number of DTS packages that have already been written, some of which will never be converted to Integration Services.
The continued support for DTS in Sql Server 2005 and 2008.
The Execute DTS 2000 Package Task in Integration Services.
The ability to upgrade to Sql Server 2005 and leave the DTS infrastructure untouched.
The popularity of DTS Package Search.

How is DTS living in your organization?