Post reply

percentage data is uploading as decimal Ex:84.56 is uploaded as .845567493892083- SSIS

  • May 20, 2014 at 8:27 am

    #286843

    Trying to extract data from excel and upload it to the SQL server. Data in the column is positive or negative decimals, but the data is not uploaded in the correct format.

    Can you please suggest.

    Checked the data if has formulas and found data to be rounded, but the original data is as

    84.372609988898777%

    18.4753467770136%

    -15.3337571519389%

    -44.9944994499449%

    2.64579839761505%

    Examples:

    Source data:

    84.56%

    18.48%

    -15.33%

    -44.99%

    2.65%

    20.97%

    Data is uploaded to SQL table as

    0.84372609988898777

    0.18475346777013599

    -0.15333757151938901

    -0.44994499449944902

    2.6457983976150502E-2

    0.209655172413793

    0.46365105008077501

  • May 20, 2014 at 1:21 pm

    #1715105

    Excel is just formatting the data as a percent for display it actually has the data stored as 0.84, etc...

    If you want the data to be stored in the database as the percent, not the decimal you need to create a derived column in the data flow and multiply the data coming from Excel by 100.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply