I've added a simple bat file to move a file from one directory to another at
the tail-end of a DTS package. Even though this task runs successfully if I
right-click, execute task from within the DTS designer, it fails when I
execute the entire package returning an error which indicates that the
return code = 1 when I set the return code = 0.

Since the task runs correctly with return code = 0 when I execute the single
task and fails with I set the return = 1, then I assume 0 = true & 1 =
false.

In either case, why would the task fail as part of the package but not when
run alone.

Thanks,
Ross

I have determined that it's a connection issue; however, I can't figure out
what the solutions is.


"Ross Culver" <rculver (AT) alliant-solutions (DOT) com> wrote