Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Null Values while loading the Excel file to the table

Answered Null Values while loading the Excel file to the table

  • Monday, January 21, 2013 8:40 AM
     
     
    Sign In to Vote
    0

    Hi,

    Loading the excel file to the table using SSIS 2005.

    Excel file contains the below columns and values

    Date Routine Days Count CntNumber
    1/11/13 XYZ 3 77 987
    1/11/13 XYZ 4 3 987
    1/11/13 XYZ 5 4 987
    1/11/13 XYZ 6 4 987
    1/11/13 XYZ 7 99 987

    ISsue:

    When tried to load the file, it load the column"CntNumber" as NULL values.

    But if we open the excel file, double click on the column "CntNumber" , save it and execute the package, it successfully loaded.

    Dont know the exact cause...

    Please advise me how to solve this issue?

    Regards

    SqlStud

     

All Replies