Microsoft Connectors v2.0 for Oracle and Teradata – Now Available

The new Attunity connectors for Oracle and Teradata are now available on Microsoft.com. This version (v2.0) supports SQL Server 2012, and adds some new functionality for SQL Server 2008 / 2008 R2 (v1.2). From the site: Microsoft Connector Version 2.0 for Oracle by Attunity – The Oracle source and destination components are written to achieve…


SQL 2012 Connectors for Oracle & Teradata Coming Soon

An updated version of the Attunity Connectors for Oracle & Teradata are not yet available on the Microsoft.com download center, but will be up there soon. The plan is to have these connectors available in Q1 of this year. The basic functionality will remain the same, with some minor updates: Support for SQL Server 2012…


Reading from Active Directory using SSIS

Fellow MSDN blogger Alex Tcherniakhovski has posted a presentation about retrieving Active Directory data using SSIS. His packages make use of a custom Active Directory Domain Source component which he built and published on his blog. The presentation does more than just show off this new source component – he also provides a good overview…


New and Improved Connectivity Wiki

We’ll soon be taking down the old connectivity wiki, and have moved all of the content to the new Technet Wiki Pages. You can find a full list of SSIS wiki pages here, or you can click through to the connectivity related pages linked below: SSIS 64 Bit Story SSIS Connectivity White Paper SSIS Connection…


Version 1.1 of the Connectors for Oracle and Teradata by Attunity now available

A new version of the SSIS connectors for Oracle and Teradata is now available from the Microsoft download site. Changes Performance Improvements for Oracle and Teradata Components Optimize conversion functions in the Oracle and Teradata source and destination components. A major performance enhancement for the Oracle destination component when set to work in fast-load mode….


Something new for SSIS in SQL Server 2008 R2 November CTP

Ok, so it turns my previous post about R2 wasn’t entirely correct. SSIS does have one new feature which appears in the latest SQL Server 2008 R2 CTP. If you open up the ADO.NET Destination UI, you’ll notice a new “Use Bulk Insert when Possible” check box. Previously, the ADO.NET Destination did all of its…


Writing to a MySQL database from SSIS

A couple of users reported being unable to use the ADO.NET destination to insert data into their mysql databases. When I originally tried this out, it worked, but it seems like changes made since the early 2008 CTPs have made us incompatible with MySQL. We do have a bug logged to make this more flexible,…


New connectivity white papers

Two new SSIS connectivity white papers have been published on MSDN. Connectivity Options for Microsoft SQL Server 2008 Integration Services by Martin Ellis This paper talks about the various connectivity options that SSIS supports, as well as the new connectors for Oracle, Teradata and SAP BI that were recently released. I was also happy to…


Attunity connectors for Oracle and Teradata are now available

The high speed connectors for Oracle and Teradata are now available for download.   Supported versions Platforms Oracle 9.2.0.4 or higher x86, x64, ia64 Teradata 2R6.0, 2R6.1, 2R6.2 and 12.0 x86, x64 Attunity has done a great job putting these together, and from what I’ve seen, the performance is really impressive. Be sure to check…


Accessing OLEDB Connection Managers in a Script

Accessing ADO.Net Connection Managers from an SSIS script task / script component is pretty easy – you just need to cast the object returned from AcquireConnection() to the appropriate class (i.e. SqlConnection if you’re using SQL Native Client). SqlConnection conn = (SqlConnection)Dts.Connections["adonet"].AcquireConnection(null); If you can’t use ADO.Net for some reason, and are using OLEDB connection…