SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Job history - DTS
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

dejjan
Yak Posting Veteran

99 Posts

Posted - 01/18/2008 :  03:08:47  Show Profile  Send dejjan a Yahoo! Message  Reply with Quote
Hello all,
does anybody knows to read errors and messages from Job History when it is referenced with some DTS.
I have DTS with dozens of steps and it is scheduled, so I have job for that. But, when job fails I want to see why it happens. So, in job history when I click details there is message like:

DTSStep_DTSExecutePackageTask_1 DTSRun OnFinish: DTSStep_DTSExecutePackageTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_4 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_5 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_6 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_3 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_3 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_7 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_4 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_8 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_5 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_11 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_11 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_14 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_6 DTSRun OnStart: DTSStep_DTSExecuteSQL... Process Exit Code 1. The step failed.

How do I know what is behind this tasks and what was the last one when step failed ?

nr
SQLTeam MVY

United Kingdom
12543 Posts

Posted - 01/18/2008 :  12:01:08  Show Profile  Visit nr's Homepage  Reply with Quote
select stepexecresult, p.name, p.starttime, s.errordescription, *
from msdb..sysdtssteplog s
join msdb..sysdtspackagelog p
on p.lineagefull = s.lineagefull
where (s.stepexecresult <> 0 or @ErrorsOnly = 'N')
and p.starttime >= @Startdate
order by p.starttime desc, p.logdate desc


==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

vinay9738
Starting Member

India
1 Posts

Posted - 08/26/2013 :  05:10:32  Show Profile  Reply with Quote
Hello,

I have DTS package that fails with below error

Executed as user: ASINTS07\Administrator. ... DTSStep_DTSExecuteSQLTask_5 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_5 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSActiveScriptTask_4 DTSRun OnFinish:
DTSStep_DTSActiveScriptTask_4 DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnFinish:
DTSStep_DTSActiveScriptTask_1 DTSRun OnStart: DTSStep_DTSActiveScriptTask_2 DTSRun OnFinish:
DTSStep_DTSActiveScriptTask_2 DTSRun OnStart: DTSStep_DTSActiveScriptTask_6 DTSRun OnFinish:
DTSStep_DTSActiveScriptTask_6 DTSRun OnStart: DTSStep_DTSActiveScriptTask_9 DTSRun OnFinish:
DTSStep_DTSActiveScriptTask_9 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_3 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_3 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_4 DTSRun OnFinish:
DTSStep_DT... Process Exit Code 1. The step failed.

Can anybody help me on this why this error occured when it was scheduled?

vinay
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 08/28/2013 :  03:30:44  Show Profile  Reply with Quote
quote:
Originally posted by vinay9738

Hello,

I have DTS package that fails with below error

Executed as user: ASINTS07\Administrator. ... DTSStep_DTSExecuteSQLTask_5 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_5 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSActiveScriptTask_4 DTSRun OnFinish:
DTSStep_DTSActiveScriptTask_4 DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnFinish:
DTSStep_DTSActiveScriptTask_1 DTSRun OnStart: DTSStep_DTSActiveScriptTask_2 DTSRun OnFinish:
DTSStep_DTSActiveScriptTask_2 DTSRun OnStart: DTSStep_DTSActiveScriptTask_6 DTSRun OnFinish:
DTSStep_DTSActiveScriptTask_6 DTSRun OnStart: DTSStep_DTSActiveScriptTask_9 DTSRun OnFinish:
DTSStep_DTSActiveScriptTask_9 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_3 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_3 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_4 DTSRun OnFinish:
DTSStep_DT... Process Exit Code 1. The step failed.

Can anybody help me on this why this error occured when it was scheduled?

vinay


you've not posted any error messages for us to understand cause of failure. Check and see if you've any error messages in log

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000