Object Reference Problem with Data Driven Query Task in DTS

• Kulvinder Gupta

  Grasshopper

  Points: 13

  More actions

  December 19, 2006 at 3:11 am

  #67898

  We created a master DTS(DTS_Master.dts) in which there are 26 execute package tasks.

  With DTS_Master.dts, we are transferring around 1.5 Lacs records. It fails on the last execute package task which transfers around 1 Lakh records and the error description is

  _______________________________________________________

  P C C O D E S    E R R O R

  _______________________________________________________

  12/18/2006 4:02:30 PM

  Package failed, error: xFFFFFFFF80040427,  xFFFFFFFF80040000 + 1063

  Execution was canceled by user.

  *********** P C C O D E S D T S S T A T U S ************************

  Package Name: DTS_Master

  Package ID:{F62ABEF0-5D10-4624-A11E-9A6490E89151}

  Step Name: DTSStep_DTSExecutePackageTask_1

  Description: DTS_PeriodTypesAndDates

  Execution Status: Succeeded

  Step Name: DTSStep_DTSDynamicPropertiesTask_1

  Description: Bind Properties

  Execution Status: Succeeded

  Step Name: DTSStep_DTSExecutePackageTask_2

  Description: DTS_GoodsAndServicesCodes.dts

  Execution Status: Succeeded

  Step Name: DTSStep_DTSExecutePackageTask_4

  Description: DTS_GBUCodes

  Execution Status: Succeeded

  Step Name: DTSStep_DTSExecutePackageTask_5

  Description: DTS_DepartmentsDisciplinesActivitiesOrgCodes

  Execution Status: Succeeded

  Step Name: DTSStep_DTSExecutePackageTask_6

  Description: DTS_Currencies

  Execution Status: Succeeded

  Step Name: DTSStep_DTSExecutePackageTask_7

  Description: DTS_RegionCountryState

  Execution Status: Succeeded

  Step Name: DTSStep_DTSExecutePackageTask_8

  Description: DTS_CORPGRADES_CORPRATEEFFECTIVEDATE_CORPRATESCHEDULES

  Execution Status: Succeeded

  Step Name: DTSStep_DTSExecutePackageTask_11

  Description: DTS_Entities

  Execution Status: Succeeded

  Step Name: DTSStep_DTSExecutePackageTask_12

  Description: DTS_TrendCategory1TrendCategory2

  Execution Status: Succeeded

  Step Name: DTSStep_DTSExecutePackageTask_13

  Description: DTS_EACODES

  Execution Status: Succeeded

  Step Name: DTSStep_DTSExecutePackageTask_15

  Description: DTS_CalendarTypes

  Execution Status: Succeeded

  Step Name: DTSStep_DTSExecutePackageTask_16

  Description: DTS_TrendEventsDesignation

  Execution Status: Succeeded

  Step Name: DTSStep_DTSExecutePackageTask_17

  Description: DTS_GrPayRollAdditives

  Execution Status: Succeeded

  Step Name: DTSStep_DTSExecutePackageTask_19

  Description: DTS_MaintainRateBasis

  Execution Status: Succeeded

  Step Name: DTSStep_DTSExecutePackageTask_20

  Description: DTS_MainTainFormulas

  Execution Status: Succeeded

  Step Name: DTSStep_DTSExecutePackageTask_21

  Description: DTS_MaintainReportLabels

  Execution Status: Succeeded

  Step Name: DTSStep_DTSExecutePackageTask_22

  Description: DTS_UOMCostCodeCostCodeDefinition

  Execution Status: Succeeded

  Step Name: DTSStep_DTSExecutePackageTask_14

  Description: DTS_UserCodeAndUserCodeValues

  Execution Status: Succeeded

  Step Name: DTSStep_DTSExecutePackageTask_9

  Description: DTS_ExpenditureType

  Execution Status: Succeeded

  Step Name: DTSStep_DTSExecutePackageTask_10

  Description: DTS_Vendors

  Execution Status: Failed

   failed, error: xFFFFFFFF80040427,  xFFFFFFFF80040000 + 1063

  (1TS_VENDORS) SubStep 'DTSStep_DTSDataDrivenQueryTask_1' failed with the following error:

  The number of failing rows exceeds the maximum specified. ( (80004005): Object reference not set to an instance of an object.)

  Execution was canceled by user.

  Step Name: DTSStep_DTSExecutePackageTask_3

  Description: DTS_MasterProjects

  Execution Status: Succeeded

  Step Name: DTSStep_DTSExecutePackageTask_18

  Description: DTS_Currencies

  Execution Status: Succeeded

  Step Name: DTSStep_DTSExecutePackageTask_23

  Description: DTS_RegionCountryState

  Execution Status: Succeeded

  Step Name: DTSStep_DTSExecutePackageTask_24

  Description: DTS_BechtelOfficesLocationWorkLocation.dts

  Execution Status: Succeeded

  Step Name: DTSStep_DTSExecutePackageTask_25

  Description: DTS_IndirectCode

  Execution Status: Succeeded

  Step Name: DTSStep_DTSExecutePackageTask_26

  Description: DTS_MasterUsers

  Execution Status: Succeeded

  **********************************************************

  _______________________________________________________

  Please suggest some solution to solve this problem.

   

  Note: DTS_Master.dts executes successfully when we call this last execute package task at first position in DTS_Master.dts. This is quite unpredictable, please suggest some work arround for this problem.

  Thanks.

  Kulvinder Gupta, Sumit Gupta.

   

   

   

• Daniel Forrester 123

  SSCrazy

  Points: 2276

  More actions

  December 19, 2006 at 7:24 am

  #678907

  This may help though it is not specific to the error message more the error code.

  http://support.microsoft.com/kb/306518

  From this KB it appears that there is an issue connecting to the data.

  Regards

  Daniel

• Jambu Krishnamurthy

  SSCrazy

  Points: 2054

  More actions

  December 20, 2006 at 11:53 am

  #679192

  this is exactly what is happening

   

  http://www.sqlservercentral.com/columnists/kjambu/2762.asp