Friday, February 24, 2012

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

I hope this is the right forum to post my question in.

Does anyone know if or when 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. I apologize if this has been asked before, but I couldn’t seem to find any posts on it.

Thanks!

Here's some info

http://blogs.conchango.com/jamesrowlandjones/archive/2007/02/18/08.04.08-is-SQL2K-day.aspx

|||Thanks!|||

Hi, your question was good and info noted before was good as well.
I thought I would point you to the official deprecation notice as well.

http://msdn2.microsoft.com/en-us/library/ms403408.aspx

Its intentionally vauge regarding timelines but the idea is to inform you of general direction and changes. You question was if at some point SQL '2005' would not support DTS 2000 pacakges, I think its fair to say no, because 2005 is out the door and in customer hands.

The real question is for how lmany future versions of SQL server support DTS 2000 pacakges. There obviously has to be a limit for practicality reasons. MSFT would like to support everything all the time but thats not realistic as it would continually hinder inovations and changes. So, the reason the depecation noitce is vauge on timeline as the exact version support is stopped may depend on how versions evolve with new features and such. Things will not just get pulled out from under you, but there is a realistic limit. The intent of the notice is similar to the blog, to inform you its needed at some point and formulating a strategy sooner rather than later is a good thing.

hope that helps

No comments:

Post a Comment