Post reply

length of string field in access database

  • March 25, 2009 at 6:59 am

    #136038

    Good day,

    I have strange problem with importing data from access table and I hope someone could explain me what I'm doing wrong.

    Access table has following structrure

    Id string(255)

    Name (255)

    But data from that table was queried by sql statment

    select

    left([id],25]) as [id]

    left[name],100) as [name]

    from table.

    When I add such statement to data flow task I get result columns of length 255 (in advanced editor for ole db source). Is it normal?

    Thanks for any help.

    Regards

  • March 25, 2009 at 7:04 am

    #965954

    Hi,

    In your select statement, you just made a trim to the columns which you are getting, and not performing the DataType operation. Hence, the DataType Length will remain the same as it is defined in the Table. If you want to resduce the DataType length then you can use the "Derived Column" Task and set the Output Length as per your requirement.

    Regards,

    Ashok S

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

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