Two observations:

1. The package runs successfully when I use max(isnull[columne_name],0) for all the max columns. These max columns are maxed in the select part using the columns returned by the...

Thanks Phil. I tried doing the SET ANSI_NULLS OFF, but it didn't work. I read about it, and in my query I am not doing any comparison where a null...

Here are the error codes:

Error: SSIS Errorcode DTS_E_OLEDBERROR. An OLEDB Error has occured. Error Code 0x80004005. An OLEDB record is available.Source Microsoft SQL Native Client.Hresult 0x000. Description "Warning a Null...