MS SQL - export tables to format compatible with PostgreSQL
Please refer to below thread. SSIS would help you in transferring data from SQL server to postgres
Micrsoft forum thread for similar issue

I have written article on how to transfer data from SQL server to postgres but this is applicable to SQL server 2008 and onwards you can read it though 

How to transfer records from sql server to postgres