Hi everyone! This is probably a simple question, but I'm a beginner using DTS.
I have a VB application that executes a DTS package when a button is pressed. Yesterday, while at one of our satellite offices, I tested the program from one workstation and it worked fine, but when I tried it from another I received an error (which I unfortunately forgot to write down). The error was something vague - something about a "Multi-step OLE DB process failed to execute". On the 2nd workstation, I even attempted to just execute the DTS package straight from SQL Enterprise Manager and still received the error, so I'm thinking that it doesn't have anything to do with the VB application.
Can anyone tell me if a client machine uses any particular DLL's when attempting to execute a DTS package on a server? Any ideas what may cause this?