SQL 2005 Integration Services integration with version 3.0

SQL 2005 Integration Services integration with version 3.0

Postby 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
Paul S
 
Posts: 5
Joined: Sat 22 Apr 2006 16:18

Postby 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.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for PostgreSQL