August 13, 2012 at 12:26 pm
Here is the error message;
[Derived Column [232]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "Derived Column" (232)" failed because error code 0xC0049067 occurred, and the error row disposition on "output column "PSOURCE_CODE" (358)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
Can you please suggest what's wrong with PSOURCE_CODE
August 13, 2012 at 12:28 pm
Sounds like an invalid character was encountered at the source and then the derived column cannot handle it. Examine the source data.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 13, 2012 at 12:31 pm
Could always set the source and destination to unicode.
August 13, 2012 at 12:43 pm
In advance editor for oledb source the output 'psource' data type is string [DT_STR] 500 length, I have the derived column set as
Psource_code= SUBSTRING(PSOURCE,3,FINDSTRING(PSOURCE,")",1) - 2)
Psource_Desc= SUBSTRING(PSOURCE,5,500)
In data conversion
Psource_code unicode string[DT_WSTR] 200
In Target table the data type Nvarchar with 200 length
The target table Psource output is as
(-9) MISSING/UNKNOWN/NOT COLLECTED/INVALID
what did I do wrong here to fix it?
August 14, 2012 at 2:08 pm
There should be more errors when this runs. This is not a primary indication error but a result of the error occurrance. Somewhere above (or perhaps below, but usually above) this one will indicate what fired the error, and that's what you'll need to find to locate what's causing the row's issue. Some piece of data, obviously, but it could be anything from a missing/added comma offsetting the columns to who knows what. Data parsing issues are notoriously difficult to troubleshoot without being at the source.
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply