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 - 2007-05-16 : 06:41:10
|
| today i have a bulk upload DTS that run's localy on nthe server.how can run a bulk upload to a remote server?do i need to instal la lcient for that?and anything else?thnaks in advancepelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-05-16 : 06:50:41
|
| How are you running it?If it's just a transform data task then you can set the destination server to the remote server (assuming you have permissions).If it's a bulk insert command then run it on the remote server.DTS is a client application so it doesn't matter where it runs - it has to connect to the server so shouldn't matter where that server is as long as it has connectivity and permissions.It's best to set the server and database names in the connections from glabal variables then you can set those variables at run time in the load command.==========================================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. |
 |
|
|
|
|
|
bulk upload to a remote server