I have a problem that stops me from using Integration Services as THE ETL tool.
My goal is to load a data warehouse type of a database. The database is MaxDB (former SAP DB), but this is not the point. Let's take ANY ODBC compliant DB and assume all I have is ODBC driver - no OLE DB driver.
I figured out how to read from ODBC source (using Data Reader and ADO.NET provider for ODBC).
Now my question is how do I output/write my data into ODBC source? When I try to use OLE DB Destination it does not give me an option to use .Net Provide for ODBC. I tried other "destinations" with no luck.
I useÃÂ this version of SQL Server 2005:ÃÂ (Microsoft SQL Server 2005 - 9.00.1187.07 (Intel X86)ÃÂ ÃÂ May 24 2005 18:22:46ÃÂ ÃÂ Copyright (c) 1988-2005 Microsoft CorporationÃÂ Standard Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
View Complete Post