Home Forums SQL Server 2005 SQL Server 2005 Integration Services Import excel file to sql server table RE: Import excel file to sql server table

  • January 24, 2008 at 2:23 am

    #771174

    keywestfl9 (1/23/2008)

    i want to append rows from excel file to sql server table

    Table has a identity column.

    How do i achieve it thru SSIS or thru DTSWizard? I get error if i the identify column with null value in excel sheet.

    Identity column has null value? Impossible.