Awesome! I love how many SQL Server integration articles there are! Thank you for calling attention to them! Did I mention that I work on SQL Server? =^) Go SQL go!
Awesome! I love how many SQL Server integration articles there are! Thank you for calling attention to them! Did I mention that I work on SQL Server? =^) Go SQL go!
Cool Durval! SQL is a really powerful tool and these wiki articles help companies use the full power of SQL in an integrated manner. Microsoft solutions are simply fantastic. Good work!
Thanks Durval! It's cool how the Wiki allows us to surface information like this by grouping the tags. Great articles that you've highlighted there too... especially the second one! ;->
Durval here is how SQL server and postgress are realted through SSIS http://social.technet.microsoft.com/wiki/contents/articles/18571.how-to-transfer-records-from-sql-server-to-postgres.aspx
I spent lot of time on this article to search for provider for connection manager and also spent time reading postgress.IMO SSIS joins SQL to other RDBMS
Ya there was no OLEDB provider for postgress I dont know whether it is now or not.One i serached was provided by Postgress which had certain cost included with it.So i moved to ADO.net