| Author |
Topic |
|
steelkilt
Constraint Violating Yak Guru
255 Posts |
 Posted - 2003-08-28 : 09:30:43
|
| My colleague is using SQL Server 2000 and wants to give me one of his DTS packages so I can use it as a template to build my own, similar package.He saved the DTS package as a structured storage file and then left it on a share for me. I saved it locally, tried to open it via "open pacakge" in SQL Server 7.0 EM, and system throws "can't find file" error. I assume this is b/c SQL Server 2k and 7.0 don't talk the same DTS packkage language.Anyone know of a way I can get this SQL Server 2000 DTS pkg loaded on my SQL Server 7.0?Thx,/Steelkilt |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-28 : 12:36:18
|
| Instead of trying to open it up from a share, move the file to one of the server's local drives, then try to open it. I am not sure if you'll be able to do it, but I would suspect that if they aren't compatible that you would get a more meaningful error. It seems to me that the error that you are getting is due to the server really not being able to get to the file or a permissions problem.Tara |
 |
|
|
steelkilt
Constraint Violating Yak Guru
255 Posts |
Posted - 2003-08-28 : 12:59:13
|
| tara,thx for taking a look at this. Yes, I did move it to one of my server's local drives. I've got it in the same folder as my other, working DTS packages. The only difference is that the troublesome package was created in SQL Server 2000 and I suspect this could be the problem. Perhaps SQL 7.0 doesn't even recognize it b/c the implementation of DTS is so different in SQL Server 2000?Anyway, any suggestions on how to export the DTS code to a text file are welcomed.thx,/Steelkilt |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-28 : 13:01:23
|
| You can't export the code to a text file, but you could export it to a VB file. It is one of the options when you do a save as. How complicated is the DTS Package? Can't it just be recreated?Tara |
|
|
|
steelkilt
Constraint Violating Yak Guru
255 Posts |
Posted - 2003-08-28 : 13:12:22
|
| very complex. need the roadmap. I'll explore the other Save As options.thx,/Steelkilt |
|
|
|
steelkilt
Constraint Violating Yak Guru
255 Posts |
Posted - 2003-08-28 : 14:36:26
|
| problem solved. sql server v7.0 can read a sql server 2k dts package as long as v7.0 is running service pak 3 or above (got the info from sqldts.com).I was trying to load the sql 2k dts pkg via my desktop edition of sql server 7.0 which does not have service pak 3. did the load on the server no problem. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-28 : 14:56:18
|
| You should always (it's the recommendation at least) install the latest service pack on the client as well as on the server. This is especially recommended for DTS.Tara |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-08-28 : 23:07:06
|
| You probably won't be able to run it though.To convert it open up all the connections, display the properties and save them. This should get rid of the properties that are added in v2000 and allow the package to be run. There may be problems but the connection settings are the usual ones.==========================================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. |
|
|
|
|
load sql 2000 DTS pkg on SQL 7.0?