Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SSIS PACKAGE FAILED

Posted on 2010-09-03
4
Medium Priority
?
628 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
[X]
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
4 Comments
 
LVL 16

Accepted Solution

by:
carsRST earned 668 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 668 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 664 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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
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.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

604 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