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)" ??
| ||||
|
feedback
|
|
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. | |||
|
feedback
|
