Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ramdas
Posting Yak Master
181 Posts |
 Posted - 2002-12-13 : 10:09:32
|
| Hi,I have DTS packages created in SQL Server 2000. Is there a way to deploy them on SQL Server 7.0. In other words is there any kind of backward compatabilty for DTS packages.2. If the DTS packages Created in SQL Server 2000 use new features added in SQL Server 2000 DTS, is there a way to run them on SQL Server 2000.ByeRamdas NarayananSQL Server DBA |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-12-13 : 10:17:09
|
| All of the sql server connections will be invalid on a pure v7 client.Note that dts is a client application so it depends on the client not the server.To get round the problem you will need to open each connection on a v7 client and click on advanced, save the properties (this will remove the references to the v2000 properties) don't reset any transformations and it should be ok.Most other things that aren't available in v7 just get ignored.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
DTS SQL 2000 -> SQL 7.0