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 |
|
pelegk2
Aged Yak Warrior
723 Posts |
 Posted - 2005-11-21 : 03:26:46
|
| how do i exporta package from one server and import in another?thnaks i nadvancepeleg(i have found that i can export as vb file)Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-11-21 : 05:39:05
|
| Save it as a structured storage file then import that.Better - why not run it from the file - then you don't have these problems - just copy to another machine or just load from a shared drive.==========================================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. |
 |
|
|
pelegk2
Aged Yak Warrior
723 Posts |
Posted - 2005-11-22 : 00:52:39
|
| i dont have a problem to move the filebut i didnt find where i can import it into the sql serverIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-11-22 : 04:58:58
|
| Right click on data transformation services in enterprise manager and open package.Then you can save it to sql server.This sp will also do it for you.http://www.mindsdoor.net/DTS/s_LoadPackageToServer.htmlon the same site there is an sp to save all packages to files.==========================================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. |
|
|
|
|
|
|
how do i import/exposrt a package