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 |
|
nmg196
Yak Posting Veteran
70 Posts |
 Posted - 2009-05-15 : 04:15:55
|
| Hi,From my .NET website, I'm executing an SSIS package. I have noticed that the package filename seems to be the path of the package on the machine the code is running on, rather than the path of the package on the server I want to execute the package on. Is there no way to somehow tell SQL Server to execute a DTS package remotely? Ie, if I run the code on my own workstation, I want the DTS package to actually run on our remote database server.Thanks,Nick |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2009-05-15 : 07:32:36
|
| You can use "sp_start_job" to kick off the package (schedule package first) that way all you are doing is executing the SP from web page. Just a solution I've done in the past and it worked out well. |
 |
|
|
|
|
|
C#: calling app.LoadFromSqlServer() on remote srvr