Hi all,
I got an error when running an sql job agent,
The package execution failed in execute task editor. as its showing red icon.
the error msg was:
MessageExecuted as user: ABC. ...sion 12.0.2000.8 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 07:04:19 Progress: 2015-08-26 07:04:20.29
Source: Incremental Update - Transfer Stage to Final tables Validating: 0% complete End Progress Progress: 2015-08-26 07:04:20.33
Source: Incremental Update - Transfer Stage to Final tables Validating: 6% complete End Progress Progress: 2015-08-26 07:04:20.34
Source: Incremental Update - Transfer Stage to Final tables Validating: 12% complete End Progress Progress: 2015-08-26 07:04:20.36
Source: Incremental Update - Transfer Stage to Final tables Validating: 18% complete End Progress Progress: 2015-08-26 07:04:20.37
Source: Incremental Update - Transfer Stage to Final tables Validating: 25% complete End Progress Progress: 2015-08-26 07:04:20.38
Source: Incremental Update - Transfer Stage to Final tables Validating: 31% complete End Progress Progress: 2015-08-26 07:04:20.39
Source: Incremental Update - Transfer Stage to Final tables Validating: 37% complete End Progress Progress: 2015-08-26 07:04:20.41
Source: Incremental Update - Transfer Stage to Final tables Validating: 43% complete End Progress Progress: 2015-08-26 07:04:20.42
Source: Incremental Update - Transfer Stage to Final tables Validating: 50% complete End Progress Progress: 2015-08-26 07:04:20.42
Source: Incremental Update - Transfer Stage to Final tables Validating: 56% complete End Progress Progress: 2015-08-26 07:04:20.42
Source: Incremental Update - Transfer Stage to Final tables Validating: 62% complete End Progress Progress: 2015-08-26 07:04:20.43
Source: Incremental Update - Transfer Stage to Final tables Validating: 68% complete End Progress Progress: 2015-08-26 07:04:20.43
Source: Incremental Update - Transfer Stage to Final tables Validating: 75% complete End Progress Progress: 2015-08-26 07:04:20.44
Source: Incremental Update - Transfer Stage to Final tables Validating: 81% complete End Progress Progress: 2015-08-26 07:04:20.44
Source: Incremental Update - Transfer Stage to Final tables Validating: 87% complete End Progress Progress: 2015-08-26 07:04:20.44
Source: Incremental Update - Transfer Stage to Final tables Validating: 93% complete End Progress Progress: 2015-08-26 07:04:20.45
Source: Incremental Update - Transfer Stage to Final tables Validating: 100% complete End Progress Progress: 2015-08-26 07:04:20.53
Source: Create Enums Enumeration Dropping table wdItemResourceType: 0% complete End Progress Progress: 2015-08-26 07:04:20.54
Source: Create Enums Enumeration Creating table wdItemResourceType: 0% complete End Progress Progress: 2015-08-26 07:04:20.54
Source: Create Enums Enumeration Creating index on table wdItemResourceType: 0% complete End Progress Progress: 2015-08-26 07:04:20.54
Source: Create Enums Enumeration Inserting into table wdItemResourceType: 0% complete End Progress Progress: 2015-08-26 07:04:20.54
Source: Create Enums Enumeration Inserting into table wdItemResourceType: 20% complete End Progress Progress: 2015-08-26 07:04:20.54
Source: Create Enums Enumeration Inserting into table wdItemResourceType: 40% complete End Progress Progress: 2015-08-26 07:04:20.54
Source: Create Enums Enumeration Inserting into table wdItemResourceType: 60% complete End Progress Progress: 2015-08-26 07:04:20.54
Source: Create Enums Enumeration Inserting into table wdItemResourceType: 80% complete End Progress Progress: 2015-08-26 07:04:20.54
Source: Create Enums Enumeration Inserting into table wdItemResourceType: 100% complete End Progress Progress: 2015-08-26 07:04:20.55
Source: Create Enums Enumeration Done: 100% complete End Progress Progr... The package execution fa... The step failed.
may i know the reason for it??
as i am new to this field can you guide me through it.
Thanks