SSIS Team Blog

Helpful information and examples on how to use SQL Server Integration Services.

SQL Server OLE DB Deprecation and Integration Services

SQL Server OLE DB Deprecation and Integration Services

Rate This
  • Comments 2

As you may already know, the SQL Native Client OLE DB provider is being deprecated. This doesn't affect other OLE DB providers or the OLE DB API. Also, the SSIS OLE DB components are not being deprecated.

In SQL Server 2012 SSIS, you can continue to use OLE DB connections and will need to for components such as the Lookup transformation and the Slowly Changing Dimension transformation that require OLE DB. In the post-Denali release, you’ll be able to upgrade and continue to operate these packages without needing to do additional work to explicitly remove OLE DB from the packages.

  • Hi

    If OLE DB "SQL Server Native Client" will be removed from next release than what about "Microsoft OLE DB Provide for SQL Server"? It seems there are two and some sources seems to talk only about SQL Server Native Client.

    Do you know if that is the same for the other OLE DB provider for SQL Server?



  • Quick question, If SSIS OLEDB is not deprecated then when we put alert on deprecated OLE DB provider in sql server. Why SSIS OLEDB provider access generate alert. it seem this handling is missing in alert or  deprecated OLEDB provider alert  is of no use

Page 1 of 1 (2 items)
Leave a Comment
  • Please add 5 and 5 and type the answer here:
  • Post