August 10, 2010 at 4:27 am
Hi,
I am facing issue when trying to export decimal data type from SQL 2008 to a flat file destination.,ex. col value with = 0.00609 in SQL 2008 is exported to .txt file as 609E-3 for many rows in the destination.
Any idea how to overcome this.
August 10, 2010 at 4:32 am
Are u using RightClick -> Export or BCP or SSIS for exporting?
August 10, 2010 at 6:40 am
Hi,
I am using SSIS package for exporting.
August 10, 2010 at 10:10 am
Check the SSIS data type. It sounds like you've read that data in as a floating point (DT_R4 or DT_R8). You'll need to read it in as a DT_NUMERIC or DT_DECIMAL type instead.
Todd McDermid - SQL Server MVP, MCTS (SQL 08 BI), MCSD.Net
My Blog - Dimension Merge SCD Component for SSIS - SSIS Community Tasks and Components
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply