SSIS error from flat file to table

  • hi,

    i am inserting data from flat file to sql table usig SSIS.

    my flat file is

    empid,empname,salary

    1,david,1000

    2,krik,3456

    3,van,4532

    4,venus,345

    my table in sql is

    create table emp

    (empid int,

    empname nvarchar(50),

    salary int)

    now when i insert int oledb des, i am getting error like

    "Column empname cannot convert between unicode and non unicode data type"

    why this is coming and how to solve it

  • try playing around with the datatype of the empname on the source between WSTR and DWSTR.

  • You're delivering to a unicode string (nVarchar) and your file source definition is most likely string instead of unicode. Modify the source to be unicode, or use the datatype converter tool and generate a new column switching from non unicode to unicode, and put that into the target table.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA

  • Use a data conversion task to convert the non unicode valuesto unicode valued, it will resolve the issue.

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

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