Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

SSIS PACKAGE FAILED

Posted on 2010-09-03
4
623 Views
Last Modified: 2013-11-10
Hi All.

I have this scenario where i have a ETL package and scheduled to run every day.It was running fine till yesterday but today i got this error i cant find what might caused to fail the package.

09/01/2010 02:00:00,Daily VGEN Cubes,Error,1,CORP-REPORTS,Daily VGEN Cubes,Process All VGEN_Cubes Staging Dimensions,,Executed as user: VGEN\SQLService. ...ion 9.00.4035.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 2:00:00 AM Error: 2010-09-01 02:00:52.35 Code: 0xC0202009 Source: Load Procedures Dimension OLE DB Destination [8086] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Unspecified error". End Error Error: 2010-09-01 02:00:52.36 Code: 0xC020901C Source: Load Procedures Dimension OLE DB Destination [8086] Description: There was an error with input column "Description" (9895) on input "OLE DB Destination Input" (8099). The column status returned was: "The value violated the integrity constraints for the column.". End Error Error: 2010-09-01 02:00:52.36 Code: 0xC0209029

Any help highly appreciated.

Thanks
0
Comment
Question by:SaiRam77
4 Comments
 
LVL 16

Accepted Solution

by:
carsRST earned 167 total points
ID: 33598456
Check to see if you allow nulls in to that field (description).  If you don't, then either provide a blank string or change the field to allow nulls.
0
 
LVL 4

Assisted Solution

by:ChadFolden
ChadFolden earned 167 total points
ID: 33598514
The error tells you that there's some kind of constraint violation on the [Description] field ... it could be that the [Description] field has a foreign key contraint and you're trying to insert a value in that field that doesn't meet the constraint defined.  
0
 
LVL 16

Assisted Solution

by:vdr1620
vdr1620 earned 166 total points
ID: 33598599
Check the constraints on the Description field in your destination table and depending on that check the values in the source column to see if all the values meet the criteria
0
 

Author Closing Comment

by:SaiRam77
ID: 33663965
Thanks All
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL SERVER - Index skipped a number 2 26
Database ERD 4 27
RAISERROR WITH NOWAIT 2 16
install report service in sccm2012 3 18
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question