Post reply

SSIS Package error

  • July 7, 2009 at 11:14 pm

    #211836

    In Control Flow tab, i have taken one excel source and mapping with excel connection manager its fine and then i want to push the data from excel to DB table so i have taken OLEDB Destination and mapped with the respective connection manager whic is having required DB table.

    And then both are linked.

    In this case i'm getting below error.

    Transaction may occur due to inserting data from data flow column "ProductName" with length of 255..this error occur in SSIS package

    Please guide me.

    Thanks in advance.

  • July 8, 2009 at 12:16 am

    #1021488

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic749033-147-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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