SSIS/DTS with SQL Server 2000?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

vegathena@gmail.com - 14 Mar 2008 16:39 GMT

I am working with a SQL Server 2005 client while the server still runs
SQL Server 2000.

SQL Server 2000 had DTS while 2005 has SSIS. Given that the server
still runs 2000, is it possible to write a DTS package in 2005 that
the server running 2000 can execute? Or is it possible that this 2000
server can run 2005 SSIS packages?

Thanks for your input.

Reply to this Message

John Bell - 15 Mar 2008 08:59 GMT

Hi

If your client has a valid SQL 2005 licence you can create another instance
on the Server and using the ADDLOCAL option when installing you can install
only the SSIS instance using SQL_DTS option
http://msdn2.microsoft.com/en-us/library/ms144259.aspx otherwise you may want
to get yourself a developer edition of SQL 2000 and install it on a virtual
machine or another computer.

John

> I am working with a SQL Server 2005 client while the server still runs
> SQL Server 2000.
[quoted text clipped - 5 lines]
>
> Thanks for your input.

Reply to this Message