March 2011 Entries

How to Import Negative Decimal or Floating Values to Flat File Without Losing Leading Zero
A question popped up not so long ago on the MSDN SSIS Forum from somebody struggling with a leading zero being dropped from the data being exported to a flat file to be returned back. The person asking was also interested in trimming (not rounding) the values to a certain scale. As an aside, this issue occurs when you have decimal or floating point numbers in a database and its value is between 0 and 1 e.g. 0.445 or a negative one e.g. -0.123 which you want to export to a flat file as CSV being used ......

Posted On Monday, March 28, 2011 3:21 PM | Comments (10)