| |
| ||||||
Flat File Sources and the Decimal Data TypeThis is a discussion on Flat File Sources and the Decimal Data Type within the BI Monkey forums, part of the CORTEX Blogs category; Question: What Data Type should you use for importing a column in Flat File containing Decimal data? Answer: numeric [DT_NUMERIC] You cannot use the decimal [DT_DECIMAL] type, because in the ... |
 |
| | LinkBack | Thread Tools | Search this Thread | Display Modes |
27th July 2009, 08:22 PM
| #1 |
| Guru Join Date: Jun 2009
Posts: 122
 |  Flat File Sources and the Decimal Data Type Question: What Data Type should you use for importing a column in Flat File containing Decimal data? Answer: numeric [DT_NUMERIC] You cannot use the decimal [DT_DECIMAL] type, because in the Advanced Editor of the Flat File connection, the decimal type for some reason only allows you to set the Scale (the number of digits after the decimal point) - the Precision is greyed out (precision is the total number of digits). The numeric data type allows the setting of both values. Fortunately the SSIS numeric type maps to SQL Server decimal columns without complaint, so you don’t have to add a Data Conversion to change numeric to decimal before using it. I have raised a bug on Connect - please vote it up if you consider this worth fixing. Get More from the original blog... |
|      |
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Flat File Source Error: The column delimiter for column [ColumnName] was not found | James Beresford | BI Monkey | 0 | 30th June 2009 12:21 PM |
| Flat File Import tips | James Beresford | BI Monkey | 0 | 23rd June 2009 09:34 PM |
| International Sources Of BOBJ Information | Jo Vincent | SAP and Business Objects Forum | 0 | 25th May 2009 04:45 PM |
| Data Mart V Data Warehousing - The geat Debate | binboy | Data Warehousing Tips and Techniques | 1 | 16th July 2008 11:15 AM |
| | |
| | |
Linear Mode
