February 3, 2012 at 5:40 am
Hi All,
I have to migrate SQL Server 2005 database to the Ingres Database using SSIS Package. For that I have created DSN using ODBC Connection for Ingres database. Now for SQL Server I have used OLEDB Source in the Dataflow Task. My question is for Ingres database which data flow destination I can use. I have tried various Data flow destination but It didn't work. I am using DSN using Ingres ODBC Driver. So, Can any one please explain me in details how to migrate from SQL Server database to Ingres Database using SSIS Package?
Experts please help me.. I would be really appreciate to all.
Best Regards,
KP
February 3, 2012 at 5:56 am
Try the OLE DB Destination using the Microsoft OLE DB for ODBC provider.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 6, 2012 at 11:55 pm
Hi,
I really appreciate for your reply. Actually, I have tried with OLEDB Destination but there is not any connection manager for "Microsoft OLEDB for ODBC". So, can you please guide me? I am working on SSIS 2005.
Please let me know any other thoughts..
Thanks,
Ketul
February 7, 2012 at 12:27 am
You are right, for some reason you can't select that provider in an OLE DB connection manager. (although the provider is installed on the server. Damn you SSIS!)
Try the following:
create an ADO.NET connection manager. In the provider dropdown at the top, go into the folder .NET providers and choose ODBC data provider. Then use the ADO.NET components in your dataflow.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply