DTS To SQL Server 2008

[Azzuri]

Hi,

I was wondering if it is possible to connect to SQL server 2008 using DTS in SQL server 2000. I need to pull data from the server running SQL server 2008. I was told it is not and need to validate.

Is there anything that needs to be installed on either side for this to work.

Any help is greatly appreciated.

Thanks.

 

[mrdenny]

Yes it'll work just fine.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog