Transfer data from MS SQL to PostgreSQL with SSIS ODBC destination
Isn't this a case for a tools rethink ? 
How about BCP from SQL Server to write out a csv text file &amp; Bulk Load on the PostgresSQL side to do the load ?