Home Forums SQL Server 2005 SQL Server Newbies SSIS not importing zipcode data correctly into SQL from Excel RE: SSIS not importing zipcode data correctly into SQL from Excel

  • September 11, 2009 at 6:43 am

    #1052219

    Added information: the datatype of the zip code field in the SQL table is nvarchar(15), null.

    Just need to get the correct zip code with 0 as first digit imported into the SQL table. Zip Codes without the 0 as first digit are being pulled into the SQL table correctly.