Home Forums SQL Server 2005 SQL Server 2005 Integration Services To insert varchar records in datetime field RE: To insert varchar records in datetime field

  • October 11, 2012 at 1:12 am

    #1547904

    Your Excel column is holding mixed datatypes, so you'll need to bring in the column as string and add IMEX=1 to the Excel connection string (Google it for details).