Post reply

SSIS Unicode&non-Unicode

  • November 18, 2008 at 9:12 am

    #383415

    I am trying to import a flat file into SQL 2005.

    The file is a .txt file with 8 columns.

    I am getting the attached error when running the package.

    Please can anyone tell me in laymans terms what the hell this means?:crazy:

    THANKS

  • November 18, 2008 at 11:40 am

    #900110

    make sure that you have varchar datatype both in source and destination. you will get that error when the datatypes are mismatched between nvarchar and varchar I guess..

  • November 20, 2008 at 11:24 am

    #901212

    Try using the Data Conversion transformation for changing the data types.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply