Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DTS To SQL Server 2008

Status
Not open for further replies.
Azzuri

Azzuri

Programmer
Joined
Apr 16, 2002
Messages
18
Location
CA
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.

 
Sort by date Sort by votes
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
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

petart
  • Locked
  • Question Question
Problem Date MS SQL Server
Replies
0
Views
776
petart
petart
botatun
  • Locked
  • Question Question
the linked server insert data to csv in wrong order
Replies
0
Views
623
botatun
botatun
mutley1
  • Locked
  • Question Question
XLSX import to DTS (SQL 2000)
Replies
0
Views
372
mutley1
mutley1
Fsoumia
  • Locked
  • Question Question
DTS Logging
Replies
2
Views
772
Fsoumia
Fsoumia
smsmail
  • Locked
  • Question Question
How to import EXCEL data into existing table in SQL Server
Replies
5
Views
1K
markjoseph1232
markjoseph1232

Part and Inventory Search

Sponsor

Back
Top