SQL 2000 DTS -> 2005 Integration Services???
-
Does anyone know if 2000 DTS packages are compatible with SQL 2005 Integration Services? I would hate to think I would have to rewrite my old DTS packages. Thanks
-
Don't worry, there is an Execute Package task in SSIS that will execute DTS2000 packages.
The DTS2000 runtime is shipped with SSIS.
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson -
Thanks Jamie. With that said, do you know if existing DTS packages that are executed with SQL jobs will have to have anything done to them to run on SQL 2005? Do you know where there is some info on this subject?
-
Now that I can't be entirely sure of but I would expect that you will still be able to do this.
Microsoft's mantra on this is "Never break existing functionality" so if you can do it in v2000 you should be able to do it in v2005.
There is a private newsgroup (that the public have access to
) called microsoft.private.sqlserver.dts which is a good resource.It can be accessed via the web but I don't have the URL to hand and I can't do a search on msdn.microsoft.com cos it seems to be down at the moment.
I will post the URL later, I have it on my laptop at home.
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson -
OK, I've found the link now. Its: http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&slcid=us
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson -
Thanks again Jamie.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply