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 |
|
rsiddiqi
Starting Member
4 Posts |
 Posted - 2005-08-01 : 15:36:45
|
| Hey, I have two servers Server A, and Server B. I want a DTS package on Server A to run a Dts package on Server B. The problem is when the DTS package on Server A calls the DTS package on server B, it seems to take a copy of it from Server B and run it on Server A instead of using server B's resources. I know this because i make the DTS package on server B create a text file on the C drive....and when i run Server A to run package on Server B, the text file gets created on Server A, not Server B. The package on Server A used to call the package on server B uses Active X Script. I need to do this cause i need Server B package to return Global Variables to Server A package. Can you guys suggest a way to get around this problem? The other thing i'm thinking of doing is making a call to a procedure on Server B from Server A, and have that procedure call the DTS package. This does run the package on Server B, but makes the DTS error checking ugly. Any other suggestions? Comments? Thanks |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-08-01 : 20:55:51
|
| dts is a client application and so will run on the machine it is loaded.Don't be confused by it's relationship with sql server. Packages can be stored in msdb but they are just stored as data and have to be extracted by the application before they run.You have to find a method of running the application on the remote server e.g. via an sp or starting a job.==========================================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. |
 |
|
|
rsiddiqi
Starting Member
4 Posts |
Posted - 2005-08-25 : 11:16:37
|
| thanks nr...i managed to break out my calls so that i have one copy of the dts packages on Server A, and i call the packages from the servers i need them to run on. Works perfectly! |
|
|
|
|
|
|
Running DTS package on different server