August 13, 2012 at 1:33 pm
SSIS failing with this error;
[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.
Here are the details
In source table, in advance editor for oledb source the output 'psource' data type is string [DT_STR] 500 length, I have the derived column set at
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
August 13, 2012 at 1:37 pm
Please don't start a new thread. It fragments replies.
http://www.sqlservercentral.com/Forums/Topic1344346-391-1.aspx
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 1:48 pm
Can you please suggest?
August 13, 2012 at 1:51 pm
Like was said in the other thread. You need to investigate the data and find what is causing the failure.
Another option was proposed that you use Unicode. Please refer to the original thread so as to prevent further fragmentation of replies.
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply