In this blog, we will discuss about Data type Conversion Issue
in SSIS Package for derived Column. recently while designing of SSIS package for
migrating data from legacy system to new
system I did a lot of data transformation regarding data type conversion, and
concatenate of multiple columns.
I used derived column component for data type conversion or concatenate
of two columns value and while concatenating of two column I got data type
conversion error.
SSIS : Column ‘XXX’ Cannot convert between Unicode and non-unicode
string data types
I performed below steps to resolve this data type conversion
issue without explicitly data type conversion :
- Open
the ‘Show Advanced Editor’ of derived column component
- Click
on “Input and Output Properties” à “Derived Column Output” à Output Column à
- Set
Data Type property of derived Column à DT_STR
After above changes, SSIS package successfully loaded data.
 Thanks for visiting !! |
No comments:
Post a Comment