Post reply

Data Conversion problem

  • August 24, 2006 at 3:34 pm

    #114219

    Hi,

    I am new to SSIS and I have created a package that is using a flat file to load data into a new ERP system we are implementing.  The problem is that the field that I'm trying to bring over from the legacy system is 20 characters and the new ERP field is 16.  If I create a Data Conversion flow and specify length 16 even though it is coming in as 20, it errors there.  If I use the default length of 50, it passes that flow ok and then errors out in the OLE DB Destination section when it's trying to load the data in the new ERP table with the error that it could not convert the data because of possible data loss.  How do I get around this without having to modify the data in the flat file?

    Thanks!

    Isabelle

    Thanks!
    Bea Isabelle

  • August 24, 2006 at 4:10 pm

    #656741

    I think your problem is that by default truncation of a column will produce an error you need to change it so that truncation does not produce an error. You can change this in the options of the data flow.

    hth

     

    David

  • August 24, 2006 at 4:27 pm

    #656745

    Thank you.  That did the trick! 

    Thanks!
    Bea Isabelle

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

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