Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Decimal Convesrion Issue from SQL Server 2000

Unanswered Decimal Convesrion Issue from SQL Server 2000

  • Monday, March 04, 2013 8:14 PM
     
     
    Sign In to Vote
    0

    I have converted a DTS package from SQL Server 2000 to a SSIS package in SQL Server 2008 R2. One of the column in a table is DECIMAL (15,2). I have selected the column as "decimal[DT_DECIMAL] in SSIS package but when I load the table it removes the decimal value from 391756.99 to 391756.00 or from 312954.24 to 312954.00.

    How can I put the precision on the decimal column in SSIS package ? DataPrecision is dimmed in the page and DataScale does not except the value 15,2 .

    Any help will be appreciated.

     

All Replies

  • Monday, March 04, 2013 8:25 PM
    Moderator
     
     
    Sign In to Vote
    0
    You need to sandwich in a Data Conversion Transformation in which you can set the exact precision.

    Arthur My Blog

     
  • Monday, March 04, 2013 8:37 PM
     
     
    Sign In to Vote
    0
    No I can't. Is is stil dimmed..............