March 14, 2013 at 12:18 am
HI All,
Am getting that error in SSIS 2008 even i changed the column length in flat file source in advanced editor..i guess its not saved so that it is giving the same error again.
So colud any body tell me how that meta data property is to be refreshed or solve this issue ?
Regards,
Ravindra
March 14, 2013 at 12:28 am
Oftentimes you need to place a derived column transformation to force the conversion.
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
March 14, 2013 at 5:26 am
I have done that column propertied like name,size , data type every thing is perfect. still am getting this error.
Error: Data conversion failed. The data conversion for column "" "" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.
please help to fix this asap.
Regrads,
Ravi
March 14, 2013 at 6:07 am
Check the advanced editor on the data source properties for input and output columns...these are often defined by a sample of data and could well be wrong, check each one, one of them is bound to smaller than expected.
'Only he who wanders finds new paths'
October 9, 2019 at 5:55 pm
If all else fails try this.
What I've experienced is that this error shows up occasionally after I've copied and pasted existing Ole DB Destination/Source element either from the same Data Flow Task or a Data Flow Task from another package and then start changing the details within.
Even when the Data Type and Length of the columns are identical, this warning still appears on occasion. This is when I delete the copied element(s) and build them from scratch. This has made the warning disappear.
My guess is that the metadata is fouled up during the copy/paste.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply