Data Conversion Question

I am using the instructions at the following link to create an update/insert load:

http://blogs.conchango.com/jamiethomson/archive/2006/09/12/SSIS_3A00_-Checking-if-a-row-exists-and-if-it-does_2C00_-has-it-changed.aspx

My input data has values that are 8 bit signed integers DT_I8. My output table uses BIGINT for the same fields. Now I know that the conversion in SSIS is BIGINT = DT_STR. The question I have is this. On the INSERT side of the OLE DB Command I did not have to convert the DT_I8 values to write to the table. HOWEVER on the UPDATE side, the update errored out UNTIL I did a data conversion to DT_STR of the same fields. Why is it different between the UPDATE side and the INSERT side

This does seem strange to me. Was the table you are managing previously created using other means In other words, did it already exist prior to you using SSIS to manage it. This is just a thought but I would creating an empty table with the same schema and test your process on the new table and see if you get the same error.

My thinking is based on my experience with Excel wherein with some data types and formats it becomes very frustrating to change the format of a cell when the cell already contained a value of a different data type; cannot recall now which specific instances this happens but just recall getting really frustrated.

Your error is definitely an interesting one!