SQL 2005 Integration Services integration with version 3.0

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
Paul S
Posts: 5
Joined: Sat 22 Apr 2006 16:18

SQL 2005 Integration Services integration with version 3.0

Post by Paul S » Fri 15 Jun 2007 21:37

Hello,

I have purchased the 3.0 version and was wondering if there is support for "Data Flow Tasks" in integration services packages. One of the most important things you can do with your data is ETL the data around. Integration services allows you to write packages that do that for you. I have tried to get the PostgreSQL .NET data provider to work as a destination from a SQL Server source and I cannot. Is there a way to do this?

Thanks,

Paul
Top
Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Mon 18 Jun 2007 06:36

As I know SSIS allows only OLE DB connections as destination objects. But PostgreSQLDirect .NET is ADO.NET data provider and has nothing to do with OLE DB.
Top
Post Reply

Return to “dotConnect for PostgreSQL”