Using the hints to set Project Properties Run64BitRuntime = FALSE, the SSIS pkg did run, but instead of the 17,622 rows that the SSIS Data Flow module shows entering the OLEDB Destination module, it only wrote out 762 rows to the SQL table?? Shows no errors either??
Under Progress tab:
[SSIS.Pipeline] Information: "component "OLE DB Destination" (304)" wrote 772 rows.
Everything is GREEN in SSIS both under Control Flow & Data Flow (shows 17,622 rows going into the OLEDB Destination module), but I am not getting all rows into my SQL table?
Any ideas or hints as to what I am doing wrong?