0

Can we still run our DTS package on SQL 2000 to pull data from a SQL 2005 database with compatibility level set to "SQL Server 2005 (90)" ??

LapTop006
  • 6,496
  • 20
  • 26
Rick
  • 45
  • 3
  • 7

1 Answers1

1

Yes, you can.

That said, there were some new datatypes introduced in 2005 (off the top of my head, XML and VARCHAR(MAX), plus user defined types) - so you'll have to look out for those as they would cause a problem.

Will
  • 408
  • 3
  • 8