I have a vb6 program that is running a DTS package (SQLServer 2000)
using DTSRun.exe. I have it logging the events. When I run the program,
it goes through everything, calls the dts, logs the events and
everything looks great! Even when you look at the log file, it says
every step executed successfully and logs that the package was executed
by the administrator. BUT when I look in my table, it is as if my DTS
package never ran. Also, I have executed the package in the command
prompt, separate from the program, by using the call I use in the
program, and it works like a charm.
I have read that the error reporting when executing a package does not
always report all errors. Does anyone know how I can either get better
error reporting, or what my problem might be?
Thanks!
J