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 |
|
richards
Starting Member
2 Posts |
 Posted - 2002-03-13 : 09:00:12
|
| I have a laptop and a desktop running the desktop version of SQL. I posted an earlier question to the forum asking how to export/import DTS packages from one server to another and had gotten two answers. One was to save the package to a text file and then import into the new server, and the other answer was to open the DTS package on the main server and do a 'save as' and change the destination server. I tried both on my desktop and they worked great.I am now trying to do import the same DTS packages onto my laptop. It has MDAC 2.6 and SQL service pack 3. (I am running SQL 7.0) When I try to either import the DTS packages which I have save to a text file or directly open the DTS packages from the main SQL server, I get:Error Source: Microsoft Data Transformation Services (DTS)Error Description: %1 could not be found.Any ideas anyone.Thanks |
|
|
Jay99
468 Posts |
Posted - 2002-03-13 : 09:22:16
|
The most important response to your last post was . . .quote:
The trick is figuring out how to open the package on the destination machine  -setbasedisthetruepath
... as to why you can't 'SAVE AS' to myLaptop, I dunno.Jay |
 |
|
|
|
|
|
Can't open/import DTS package