Post reply

Import fails using SQL Server Import and Export Wizard

  • July 20, 2012 at 7:40 am

    #1515525

    I am able to solve this issue

    1.Change the data types for the following columns in the source

    ProductID - Four byte Signed Integer(DT_I4)

    Name - DT_WSTR(50)

    ProductNumber - DT_WSTR(50)

    2.Add derived column to the package

    Create new derived column for the MakeFlag Column and add expression "MakeFlag=="False"? "0":"1""

    3.Map the newly derived column in the destination

Viewing post 16 (of 15 total)

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