Note to myself, DO NOT USE a ‘Data Conversion’ transformation component in SSIS…:S

When it seems too easy with SSIS, you’ll probably need to fix it afterwards 🙂
Today in a blurry moment I didn’t think twice about using a ‘Data Conversion‘ transformation component and look what happened during processing:

ssis-2012-data-conversion-data-value-cannot-be-converted-for-reasons

The data value cannot be converted for reasons other than sign mismatch or data overflow.


A very vague error message that doesn’t really help. Googling doesn’t help either:
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/7307def1-79d3-4203-bec0-ba8d7311c30c/ssis-convertion-function-from-integer-to-string
http://stackoverflow.com/questions/11990178/date-casting-issue-in-data-conversion-task

One suggestion, delete the ‘Data Conversion’-component and drag a ‘Devired Column’-component onto your data flow plane. That makes life easier.
Most common things are blanc/white spaces or dot (‘.’) versus comma (‘,’) issues:

(DT_UI4)LTRIM(RTRIM())
(DT_NUMERIC,19,4)REPLACE(,".",",")








Advertisements

One thought on “Note to myself, DO NOT USE a ‘Data Conversion’ transformation component in SSIS…:S

  1. Pingback: Note to myself, DO NOT USE a ‘Data Conversion’ transformation component in SSIS…:S | Ragnarok Connection

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s