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 |
|
murrayb3024
Yak Posting Veteran
79 Posts |
 Posted - 2005-05-09 : 12:56:13
|
| I built a little vb app that calls a DTS package in the SQL Server. I have it running on my machine, and it works correctly. I now want to run the vb app on a client machine. The problem I have is that the client machine has no SQL server on it. The VB app makes reference to Microsoft DTSPackage Object Library. I read that I only needed to install the dtspkg.dll to run the vb app. I tried to manually register the dll but I get the following error:LoadLibrary("dtspkg.dll") failed - The specified module could not be found.Is there something I am missing? Is this what I have to do to run the vb app and call the DTS package. We don't want to install the Enterprise manager tool on the client machine. Any ideas? |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2005-05-09 : 13:34:28
|
| Couldn't you just connect to the database and call sp_startjob which could call a job that runs your dts package? Or you could check out the dts run utility.Mike"oh, that monkey is going to pay" |
 |
|
|
murrayb3024
Yak Posting Veteran
79 Posts |
Posted - 2005-05-10 : 13:04:21
|
| I would rather just call the DTS package. Any other ideas? |
|
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2005-05-10 : 13:43:18
|
dtsrun like mike suggested... its a DOS call or such.Corey Secret Service Agent: Mr. President, you're urinating on me.President Lyndon Johnson: I know I am. It's my prerogative. |
|
|
|
murrayb3024
Yak Posting Veteran
79 Posts |
Posted - 2005-05-10 : 14:28:18
|
| There is the DTSRUN tool, but that is way to complicated for a client to use. But are you saying that I can use the vb to call that tool so the end user doesn't see it? |
|
|
|
|
|
|
Using VB to call a DTS package...