Geeks With Blogs

Arthur Zubarev Compudicted 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

Copyright © Compudicted | Powered by: GeeksWithBlogs.net | Join free