sql server data type.

  • i have a column that is varchar(100) iso_1.

    it is having trouble to accept a column from a flat file. i was thinking of using data conversion to change the destination data type before it is making to the column in the table as a OLEDB dest.

    After trying using most of the datatype in the data conversion, it is still giving me the same error.

    what's wrong and how to import it?

    is there a tutorial of a fool proof way to import flat file?

    thanks.

  • Without more information, this is impossible to answer.

    Please post the full text of the error message you are receiving.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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