Post reply

Changing datatype from flatfile to table...

  • November 30, 2007 at 5:51 am

    #118988

    I have this package, where a fatfile is read and data inserted into a table. I get this datatype error: cannot convert between unicode and non-unicode datatype. Short from changing the datatype in the destination table from nvarchar to varchar, is there an easy way to change the datatype from the flatfile? I cannot start a querybuilder in the flatfile source...

    Greetz,
    Hans Brouwer

  • November 30, 2007 at 10:48 am

    #756072

    In the connection manager for your flat file, under the Advanced heading, you can specify the internal data type for each incoming column to match the desired output type, e.g. DT_STR or DT_WSTR. Alternately, you can send the incoming columns through a derived column transformation in the data flow to convert their type.

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

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