Page 1 of 1

SQL 2005 Integration Services integration with version 3.0

Posted: Fri 15 Jun 2007 21:37
by Paul S
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

Posted: Mon 18 Jun 2007 06:36
by Alexey
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.