February 16, 2011 at 11:05 am
Yep, different errors. These are easier to deal with:
OnError CRM CRM\Administrator Package {32833F60-011C-44C1-AE01-DE591DC521B8} {0A292E65-3966-4E42-810E-AF6857A821DC} 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: "Invalid character value for cast specification".
16/02/2011 11:37:18 16/02/2011 11:37:18
OnError CRM CRM\Administrator Data Flow Task {25953080-4815-49F6-B918-1DF2D76F34A9} {0A292E65-3966-4E42-810E-AF6857A821DC} There was an error with input column "C_achieve" (559) on input "OLE DB Destination Input" (29). The column status returned was: "The value could not be converted because of a potential loss of data.".
This will fail the process unless you've modified your failure items. What's the source data of C_achieve, what's the DDL of the target table that it's trying to feed, and what is the metadata in the datastream (doubleclick the arrow feeding the final dropoff and look at the metadata item) of the item you've mapped into C_achieve?
All of this will help you to derive where you're running into a conversion error.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 17, 2011 at 3:25 am
Hi,
The c_achieve is a varchar 100 null in both source and destination table. I went to the meta data by doing what you instructed and I copied the data to the memory, see below. Does that help?
"Name""Data Type""Precision""Scale""Length""Code Page""Sort Key Position""Comparison Flags""Source Component"
"E_code""DT_STR""0""0""16""1252""0""""OLE DB Source"
"E_name""DT_STR""0""0""60""1252""0""""OLE DB Source"
"E_EDRS""DT_STR""0""0""9""1252""0""""OLE DB Source"
"L_ID""DT_STR""0""0""12""1252""0""""OLE DB Source"
"L_name""DT_STR""0""0""51""1252""0""""OLE DB Source"
"L_nin""DT_STR""0""0""40""1252""0""""OLE DB Source"
"L_phone""DT_STR""0""0""20""1252""0""""OLE DB Source"
"L_mobile""DT_STR""0""0""20""1252""0""""OLE DB Source"
"L_email""DT_STR""0""0""50""1252""0""""OLE DB Source"
"L_sex""DT_STR""0""0""1""1252""0""""OLE DB Source"
"L_disab""DT_STR""0""0""3""1252""0""""OLE DB Source"
"C_code""DT_STR""0""0""20""1252""0""""OLE DB Source"
"C_title""DT_STR""0""0""100""1252""0""""OLE DB Source"
"C_level""DT_STR""0""0""1""1252""0""""OLE DB Source"
"C_start""DT_DBTIMESTAMP""0""0""0""0""0""""OLE DB Source"
"C_expend""DT_DBTIMESTAMP""0""0""0""0""0""""OLE DB Source"
"C_achieve""DT_STR""0""0""100""1252""0""""OLE DB Source"
"C_actend""DT_DBTIMESTAMP""0""0""0""0""0""""OLE DB Source"
"C_tutor""DT_STR""0""0""52""1252""0""""OLE DB Source"
"C_impact""DT_STR""0""0""100""1252""0""""OLE DB Source"
"E_addr1""DT_STR""0""0""40""1252""0""""OLE DB Source"
"E_addr2""DT_STR""0""0""40""1252""0""""OLE DB Source"
"E_addr3""DT_STR""0""0""40""1252""0""""OLE DB Source"
"E_addr4""DT_STR""0""0""40""1252""0""""OLE DB Source"
"E_addr5""DT_STR""0""0""40""1252""0""""OLE DB Source"
"E_pcode""DT_STR""0""0""10""1252""0""""OLE DB Source"
"E_phone""DT_STR""0""0""20""1252""0""""OLE DB Source"
"E_email""DT_STR""0""0""50""1252""0""""OLE DB Source"
February 17, 2011 at 9:45 am
That's odd.
"C_achieve" "DT_STR" "0" "0" "100" "1252" "0" "" "OLE DB Source"
That's a VARCHAR(100) in the stream. Well, you could tell it to just redirect failure rows, send the red arrow to a recordset destination (really just so it has somewhere to go), and take a look at the dataviewer on the failed objects to see if that'll help detect what's going on.
This is getting to the point where I'd need to see the entirety of the thing, including source and target data, the works. Something's very strange here. Hopefully someone else can think of another way to approach troubleshooting this at a distance.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
February 17, 2011 at 9:51 am
Are there any transformations at all on that column? Derived column or anything else?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 17, 2011 at 10:04 am
Thanks for your replies. Since my last post i have been tryin gall sorts of things and have got a few new errors but i think they are the last ones.
Now this field that the error is talking about 'uniqueid_auto_no' is being is set to be ignored so i'm not sure why i'm getting this error. The field is an int field and set to auto incrementing by SQL. I have to have a primary key field in the table so i figured one that generates it's own id was the best logic.
Any Ideas? Thanks again
OnError,CRM,CRM\Administrator,Data Flow Task,{25953080-4815-49F6-B918-1DF2D76F34A9},{9AF1F4F6-2D87-4375-9BAE-4D21A6C1786E},17/02/2011 10:28:28,17/02/2011 10:28:28,-1071636471,0x,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: "The statement has been terminated.".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Cannot insert the value NULL into column 'uniqueid_auto_no', table 'wce_crm4fe.dbo.wce_course_delegate_link_2'; column does not allow nulls. INSERT fails.".
OnError,CRM,CRM\Administrator,Package,{32833F60-011C-44C1-AE01-DE591DC521B8},{9AF1F4F6-2D87-4375-9BAE-4D21A6C1786E},17/02/2011 10:28:28,17/02/2011 10:28:28,-1071636471,0x,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: "The statement has been terminated.".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Cannot insert the value NULL into column 'uniqueid_auto_no', table 'wce_crm4fe.dbo.wce_course_delegate_link_2'; column does not allow nulls. INSERT fails.".
February 18, 2011 at 6:30 am
Might be the "Keep Identity" checkbox in the [OLD DB Destination Editor] is checked...
Viewing 6 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply