August 13, 2015 at 12:52 pm
Hello,
Load data to SQL Server table thru SSIS using dataflow Task and Getting SQL constraint errors, and need to Log those errors with SSIS so that finally to know how many rows failed and what reason. On debug from SSIS the below is what seen as error.
Thanks so much for your help, Very much appreciated.
============================================
Error: 0xC0202009 at XB, OLE DB Destination [320]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Conversion failed when converting the varchar value 'This is a custom error. If LCN Structure is not blank, the LCN must match an indenture level length specified by the LCN Structure, or be greater length than the total of all LCN Structure indenture levels.' to data type int.".
==================================================================
August 13, 2015 at 1:40 pm
Unfortunately not a simple thing to do and any way to do it has performance implications. You can't use Fast Load because that uses bulk insert and not a row by row insert. I wrote an article here on SSC a few years ago that applied to SSIS 2005, but I believe it is still relevant in later versions. Here's the article[/url].
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 13, 2015 at 2:47 pm
Thanks Jack, your article puts me in right direction, Thanks for your help, very much appreciated.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply