If anyone else has this issue, I found that changing the SQL Destination from SQL Authentication to Windows Authentication worked for me.