Try using single quotes instead of double quotes....

@IssueDate= '2006-10-16 00:00:00:000'

Just like what you did with @IssueTime.....

,@IssueTime='9:58:46 AM'                

You could also try this script, it loops until the total count of updated records is greater than the number of records retrieved.

Declare @TotRec as Numeric(18), @Cnt as Numeric(18)

Select @TotRec...

here's the exact error message on the package logs:

Step Error Source: Microsoft Data Transformation Services (DTS) Package

Step Error Description:Error Code: 0

Error Source= Microsoft OLE DB Provider for SQL Server

Error Description:...