Is DTS Support in 2005 Going Away Permanently at Some Point?

[fuzzyocelot]

Does anyone know when or if Microsoft will discontinue support for 2000 DTS Legacy packages within SQL Server 2005? We’re in the process of migrating from 2000 to 2005 and have a lot of packages to migrate to Integration Services. We’re having problems migrating the packages because quite a few of them are complex and won’t run after migrating to IS without a major rewrite. Right now it seems that those packages will run just fine under the Legacy folder on the 2005 instance with the data connections pointed to 2005 databases. We’d just like to plan appropriately if we absolutely have to migrate those packages to IS at some point soon. We realize that we'll need to create new packages using IS, though.

So I’d appreciate it if anyone has heard anything to please let me know.

Thanks!

 

[mrdenny]

From what I've read and understand support for DTS will go away when the next release of SQL Server comes out (SQL 2005 R2 / 2007, etc).

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[fuzzyocelot]

Thank you for replying, mrdenny.

From what you've said, I sure hope DTS support doesn't go away that quickly! That is a very scary thought for us! We have only two SQL Server DBAs (including myself) and one Oracle DBA who might be able to help us out in a pinch. However, she's the only Oracle DBA we have and is quite busy. Migrating somewhere around 70+ DTS packages to IS is going to be a pain and will definitely take some time to do since there are only the two of us to do the entire 2005 migration on multiple servers (development, production, disaster recovery). The production server alone has over 100 databases. And these are our main servers. We may end up migrating even more servers down the road. We're just getting started with the migration, and it's looking like we have a lot of work ahead of us. Sorry for rambling.

Anyway, thanks for the information and I'll keep my ears open for updates.

 

[mrdenny]

It's not that quickly. You've probably got 18-24 months before the next release. SQL 2005 will always support it, it's just that the next version won't support DTS.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[fuzzyocelot]

Sorry if I seemed to panic. We just have a lot of work to do and something always seems to come up when we least expect it. A timeframe of 18-24 months isn't too bad. If SQL 2005 will always support DTS, then that should give us a good amount of time to figure out our legacy DTS package migration to IS. We were just worried that at some point Microsoft would discontinue support of DTS within 2005 and are just trying to prepare the best we can.

My background is in programming so I'm a bit new the DBA world. I'll catch on eventually.

Thanks again!

 

[mrdenny]

Ah. You should be fine in SQL 2005.

But you will have to migrate before you can upgrade beyond SQL 2005.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[fuzzyocelot]

Whew! We had already pretty much guessed that if we want to go beyond 2005 down the road then we'll need to migrate our legacy DTS packages at some point. At least they should work as DTS packages for the time being.

Thanks!