Error I got for the Job Failure

• bubby

  SSCertifiable

  Points: 5638

  More actions

  March 14, 2008 at 10:38 am

  #187428

  Can I get the help with this please,

  Executed as user: ICS\sqlsrvr. ...n OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220482 (800403FE) Error string: [Microsoft][ODBC SQL Server Driver][SQL Server]SQL Mail session started. Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 Error Detail Records: Error: -2147220482 (800403FE); Provider Error: 0 (0) Error string: Error Code: 0 Error Source= Microsoft OLE DB Provider for ODBC Drivers Error Description: [Microsoft][ODBC SQL Server Driver][SQL Server]SQL Mail session started. Error on Line 151 Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4500 Error: -2147217900 (80040E14); Provider Error: 17971 (4633) Error string: [Microsoft][ODBC SQL Server Driver][SQL Server]Stopped SQL Mail session. Error source: Microsoft OLE D... Process Exit Code 1. The step failed.

  Thanks,

  Dev

• Adam Bean

  One Orange Chip

  Points: 26631

  More actions

  March 14, 2008 at 10:50 am

  #789759

  Like most DTS packages, you don't get the full error in the agent log ...

  This SQL Mail session started is not telling us much ...

  You need to pull out the error from sysdtssteplog:

  DECLARE

  @PackageNameVARCHAR(128)

  ,@LineageFullUNIQUEIDENTIFIER

  SET @PackageName = 'DTSPackageNameGoesHere'

  SET @LineageFull =

  (

  SELECT TOP 1 lineagefull

  FROM msdb.dbo.sysdtspackagelog

  WHERE name = @PackageName

  ORDER BY endtime DESC

  )

  SELECT

  stepname

  ,stepexecstatus

  ,stepexecresult

  ,starttime

  ,endtime

  ,errorcode

  ,errordescription

  FROM msdb.dbo.sysdtssteplog

  WHERE lineagefull = @LineageFull