Monday, January 25, 2016

Data conversion in SSIS package

When we create a SSIS package and run the package after mapping the columns we might receive error saying "Cannot Convert between Unicode and Non Unicode String Data Type

This can be resolved using Data conversion

1) Add the  conversion item to our dataflow

2) Configure the properties for data conversion as shown below. We would get an alias to from the source to map to the destination column.
3)Map the alias to the destination column

No comments:

Post a Comment