Home Forums SQL Server 2005 SQL Server 2005 Integration Services Import Data From Excel as varchar RE: Import Data From Excel as varchar

  • September 30, 2008 at 2:42 am

    #878709

    Welcome to one of the most irritating nuances of SSIS. Text is seen as NVarchar and not Varchar. In other words, if you have a text (10), make it Nvarchar (20).

    You can use a dataconversion transformation to get past this.

    ~PD