SQL Server Data tools (Integration services) tools allows the third party Intgeration with SQL Server Integration Project which comes with Visual studion.
SSIS does not have buit-in Integration with PostgreSQL but allows integration through third party Applications.
Go to Visual studion 2019. In Extensions menu Manage Extensions.
Search with Postgre.
The first one Npgsql PostgreSQL Integration is free but does not support using SSIS. We can use this only for server explorer which can be intrgrated using Visual Studio .Net.
There are many vendors which provides 30 days trial period. One of them is SSIS PostgreSQL Source. when click on download it will redirect to the page
Download SSIS PowerPack - 30 Day FREE Trial Includes: | ZappySys
After registering you can download and use trial version for a month. This application provides many connector source systems not only PsotgreSQL.
These are the different connector available after installing the software. Postgre is also there, I have highlighted the same.
But I feel it do not have any option to create a table if does not exist. Table must exist in SQL server.
Their connections are working fine as exptected. I ran one SSIS task to load one sample table it working fine.
Package execution was sucessfully after mapping the columns. But there should have been an option to create destination table based on source table columns this is only one drawback i have seen in this product.
Other Vendor who is supporting free. But they also support basic featres. That will redirect to the page
No comments:
Post a Comment