Abrar Ahmad_ (4/29/2010)
There is missing any concrete example "Not Concrete Programming " to get rid of problem "Data could not be imported because text was truncated or characters do not exist in the destination codepage"
If i identified it is the code page conflict... how it can be done with in the code, rather than to manually change the destination/code pages.
Any Concrete or Flexible bee over it?
In SSIS, an example of how to identify and correct would be:
CODEPOINT(ColumnName) < MinCodePageValue || CODEPOINT(ColumnName) >MaxCodePageValue ? (DT_WSTR,26)NULL(DT_WSTR,26): (DT_WSTR,26)ColumnName
a T-SQL equivalent would be:
WHEN ASCII(ColumnName) < MinCodePageValue OR ASCII(ColumnName) > MaxCodePageValue THEN NULL
END AS ColumnName
Space, the final frontier? not any more...
All limits henceforth are self-imposed.“libera tute vulgaris ex”