Posted by Connie on 05/04/07 16:49

On May 4, 10:42 am, rshivara...@gmail.com wrote:
> On May 4, 10:33 am, Connie <csaw...@rwbaird.com> wrote:
>
> > On May 4, 9:23 am, Connie <csaw...@rwbaird.com> wrote:
>
> > > On May 4, 9:18 am, rshivara...@gmail.com wrote:
>
> > > > Are you logging the dts
>
> > > yes in the package properties I have logging checked and I am logging
> > > to the sql server that this process is running on milnpprodsql, using
> > > the sa login and password.
>
> > Where does this log to?? I cannot find a log on the server??
>
> go to the dtspackage in enterprise manager\Data transformation Services
> \Local Packages and right click the dts and you can find the Package
> logs in it.

Duh I'm sorry I know those were there but I just didn't make the
connection, bad day! The error doesn't really hellp me much



Step Error Source: Microsoft Data Transformation Services (DTS)
Package
Step Error Description:CreateProcessTask
'DTSTask_DTSCreateProcessTask_1': Process returned code 1, which does
not match the specified SuccessReturnCode of 0.
Step Error code: 80040496
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:4900

This is the step that is moving the PDF files and I can confirm that
it is completing. I selected workflow properties for this task and on
the options tab Use ActiveX Script is selected, since I am not using
any activex script in this DTS job could that be causing the error??

[Back to original message]