Yes that is correct

There are no error messages in the All Execution report. I created a table that gets populated when there are any errors when job gets executed. This is where I...

It returns the value of 176. Not sure what that means

I've tried Native OLE DB, Microsoft OLE DB Provider for SQL Server and Microsoft OLE DB Driver for SQL Server and still was getting the same error.

Yes datetime is the actual datatype of the column.

Can you list some of them?