SSIS-Converting blanks characters to numeric in txt file



Sample Data File
XY6 628428121312 0.000 569120.390 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 X
XY5 628428121312
Col 1 - 3 char
col 2 - 16 characters (decimal field if not present then it will be spaces)
col3 - 12 characters
In the import flat file source task I hv declared all the fields as dt_str and then I
have a conversion task which converts the above 3 fields as follows
col1 -> dt_str
col2 -> dt_numeric (this is the only conversion which fails becoz in above step col2 which is decimal field is blank)
col3 --> dt_str
How can i handle this?
Any input is appreciated
Suresh








Get Source Code

  Views 73   Posted on : Sunday, July 07, 2013 7:56:51 AM
Related Tags:




Replies on "SSIS-Converting blanks characters to numeric in txt file" :

Nobody has replied on this post , be first to post answer.


Post Your Answer/Comment:

Please Login first to post Reply !


Note: Please Put Code into <code></code> block.




Also See: