> Is there no error code there ? Expected would be 80040005

> > Error from Jobs below...
> > Executed as user: DOMAIN\svcSQL. ...OnStart:
DTSStep_DTSExecuteSQLTask_2
> > DTSRun OnStart: DTSStep_DTSExecuteSQLTask_6 DTSRun OnFinish:
> > DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart:
DTSStep_DTSExecuteSQLTask_1
> > DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_6 DTSRun OnFinish:
> > DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_1
> > DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 1000 Rows have been
> > transformed or copied.; PercentComplete = 0; ProgressCount = 1000
DTSRun
> > OnProgress: DTSStep_DTSDataPumpTask_1; 2000 Rows have been transformed
or
> > copied.; PercentComplete = 0; ProgressCount = 2000 DTSRun OnProgress:
> > DTSStep_DTSDataPumpTask_1; 3000 Rows have been transformed or copied.;
> > PercentComplete = 0; ProgressCount = 3000 DTSRun OnProgress:
> > DTSStep_DTSDataPumpTask_1; 4000 Rows have been transformed or copied.;
> > PercentComplete = 0; ProgressCount = 4000 DTSRun OnProgress:
> > DTSStep_DTSDataPumpTask_1; 5000 Rows have been transformed o... Process
> > Exit Code 1. The step failed.

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:uKdldS8zDHA.2240@TK2MSFTNGP10.phx.gbl...
> You are too kind !
>
> Have the package log to text file.
>
>
> Log in to the server as the account under which the SQL Server Agent is
> started and now interactively execute the package
>
> Any more errors ?

> Glad we helped
>
> showing the results of jobs in EM executes sp_help_jobhistory
>
> It returns in the resultset "message" which is an nvarchar(1024)
>
> so yes the output is curtailed

"REM7600" <rem7600@hotmail.com> wrote in message
news:uu8X8q7zDHA.1760@TK2MSFTNGP10.phx.gbl...
> note: I posted under Uri's thread too... Sorry, should've just posted
> here...
>
> Hey Allan,
>
> How 'bout some help with this one?
>
> Runs fine when I run manually from EM. When I schedule the job and assign
> it the svcSQL account it fails... What has me baffled is that it
processes
> the datapumptask_1 a little bit(looks like 5000ish rows) and then fails.
I
> could understand if it just failed to process, but why the partial
> processing?
>
> Thanks for any help you might provide!
>
> Travis
>
> Error from Jobs below...
> Executed as user: DOMAIN\svcSQL. ...OnStart: DTSStep_DTSExecuteSQLTask_2
> DTSRun OnStart: DTSStep_DTSExecuteSQLTask_6 DTSRun OnFinish:
> DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1
> DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_6 DTSRun OnFinish:
> DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_1
> DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 1000 Rows have been
> transformed or copied.; PercentComplete = 0; ProgressCount = 1000 DTSRun
> OnProgress: DTSStep_DTSDataPumpTask_1; 2000 Rows have been transformed or
> copied.; PercentComplete = 0; ProgressCount = 2000 DTSRun OnProgress:
> DTSStep_DTSDataPumpTask_1; 3000 Rows have been transformed or copied.;
> PercentComplete = 0; ProgressCount = 3000 DTSRun OnProgress:
> DTSStep_DTSDataPumpTask_1; 4000 Rows have been transformed or copied.;
> PercentComplete = 0; ProgressCount = 4000 DTSRun OnProgress:
> DTSStep_DTSDataPumpTask_1; 5000 Rows have been transformed o... Process
> Exit Code 1. The step failed.
>
>
>

"REM7600" <rem7600@hotmail.com> wrote in message
news:uri$Jt9zDHA.2408@tk2msftngp13.phx.gbl...
> Thanks Guys... I learn a little more each day! :-)
>
> Darren, I'm curious, what do you suggest as a replacement for using the
MAPI
> sessions?
>
> Travis
>
>
> > Glad we helped
> >
> > showing the results of jobs in EM executes sp_help_jobhistory
> >
> > It returns in the resultset "message" which is an nvarchar(1024)
> >
> > so yes the output is curtailed
>
>

"REM7600" <rem7600@hotmail.com> wrote in message
news:eNu6g%237zDHA.1660@TK2MSFTNGP09.phx.gbl...
> WYSIWYG
>
> Event Viewer/Application Logs shows the failure but nothing of use
> Nothing of use in the SQL Server Logs either...
>
> Did I stump "The Master"?
>
> :-)
>
> Travis
>
> > Is there no error code there ? Expected would be 80040005
>
> > > Error from Jobs below...
> > > Executed as user: DOMAIN\svcSQL. ...OnStart:
> DTSStep_DTSExecuteSQLTask_2
> > > DTSRun OnStart: DTSStep_DTSExecuteSQLTask_6 DTSRun OnFinish:
> > > DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart:
> DTSStep_DTSExecuteSQLTask_1
> > > DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_6 DTSRun OnFinish:
> > > DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart:
DTSStep_DTSDataPumpTask_1
> > > DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 1000 Rows have been
> > > transformed or copied.; PercentComplete = 0; ProgressCount = 1000
> DTSRun
> > > OnProgress: DTSStep_DTSDataPumpTask_1; 2000 Rows have been
transformed
> or
> > > copied.; PercentComplete = 0; ProgressCount = 2000 DTSRun
OnProgress:
> > > DTSStep_DTSDataPumpTask_1; 3000 Rows have been transformed or copied.;
> > > PercentComplete = 0; ProgressCount = 3000 DTSRun OnProgress:
> > > DTSStep_DTSDataPumpTask_1; 4000 Rows have been transformed or copied.;
> > > PercentComplete = 0; ProgressCount = 4000 DTSRun OnProgress:
> > > DTSStep_DTSDataPumpTask_1; 5000 Rows have been transformed o...
Process
> > > Exit Code 1. The step failed.
>
>

>WELL, here's the scoop... I logged into the svcSQL account and tested
>manually, most of it worked except that the "SendMail" routine in the
>package failed... I had gone into the account and tested the e-mail prior
>under support services... BUT... Obviously something was wrong so I copied
>the MS EXCHANGE SERVER settings to a profile called Outlook I immediately
>started getting the report e-mail to me by the scheduled job!
>

>All I can figure is that the number of lines or amount of text reported in a
>job step failure is limited and although it looked like the DataPump was
>failing, it was actually the final object SendMail routine that was failing.
>
>Allan can you confirm (or deny) that the job detail is always valid?
>Limited rows? characters?

"REM7600" <rem7600@hotmail.com> wrote in message
news:ePHGAg8zDHA.2476@TK2MSFTNGP09.phx.gbl...
> WELL, here's the scoop... I logged into the svcSQL account and tested
> manually, most of it worked except that the "SendMail" routine in the
> package failed... I had gone into the account and tested the e-mail prior
> under support services... BUT... Obviously something was wrong so I
copied
> the MS EXCHANGE SERVER settings to a profile called Outlook I immediately
> started getting the report e-mail to me by the scheduled job!
>
> All I can figure is that the number of lines or amount of text reported in
a
> job step failure is limited and although it looked like the DataPump was
> failing, it was actually the final object SendMail routine that was
failing.
>
> Allan can you confirm (or deny) that the job detail is always valid?
> Limited rows? characters?
>
> Thanks for the help! Remember, U Da Man!
>
> :-)
>
> Travis
>
> "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
> news:uKdldS8zDHA.2240@TK2MSFTNGP10.phx.gbl...
> > You are too kind !
> >
> > Have the package log to text file.
> >
> >
> > Log in to the server as the account under which the SQL Server Agent is
> > started and now interactively execute the package
> >
> > Any more errors ?
>
>