none
Copy activity fails when copying from DB2 source

    Question

  • Hi, 

    I am trying to copy data from a DB2 source. I used 'SELECT Col1, Col2, Col3.... FROM Table1' query and it fails with error message :

    Activity Copy F4211 From E1 failed: Failure happened on 'Source' side. 'Type=Microsoft.HostIntegration.DrdaClient.DrdaException,Message=HISMPCB0014 In BasePrimitiveConverter an invalid packed decimal value was encountered. SQLSTATE=HY000 SQLCODE=-343,Source=Microsoft.HostIntegration.Connectors,'

    I've checked and found that the data source does contain 'packed decimals'.

    However when I use 'SELECT * FROM Table1' ....It works just fine.

    Could anyone please help understand this.

    Thanks.

    Thursday, August 23, 2018 1:59 PM

All replies