Browse by Tags

Tagged Content List
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: Improved error messages about missing OLEDB providers

    We've modified the OLEDB_NOPROVIDER error to return the name of the provider we failed to find. This will appear in the RC0 release of SQL 2008. SSIS Error Code DTS_E_OLEDB_NOPROVIDER_ERROR.  The requested OLE DB provider SQLNCLI.1 is not registered. Error code: 0x0000000 This should help in debugging...
  • Blog Post: Package upgrade - connection strings

    We tried to make our package upgrade as seamless as possible, but one problem we've seen people running into is with their connection strings. As I've previously noted, the provider name for SQL Native Client was changed in 2008 from SQLNCLI to SQLNCLI10. This will could cause your connection managers...
  • Blog Post: Some notes about SQL Native Client in 2008

    The SQL Native Client (SNAC) provider was renamed from SQLNCLI to SQLNCLI10 in 2008. The means that connection strings that used the Yukon provider (SNAC9) won't work if you only have the Katmai provider (SNAC10) installed. This will affect most SSIS users, as we use SNAC as the default connection manager...
  • Blog Post: New connectivity options in 2008

    Update: 2008-08-13 - The connector pack will be available two to three months from the GA of SQL 2008 Update: 2008-10-02 - The Oracle and Teradata connectors are now available Update : 2008-11-26 - The SAP BI connections are available Darvey Lavender, group program manager for SSIS, has updated...
  • Blog Post: Connecting to MySQL from SSIS

    Update: See this follow-up post on writing data to MySQL . I've recently seen a bunch of questions about connecting to MySQL from SSIS, so I thought I'd give it a try. My overall findings was that while there were quirks, both the ODBC and ADO.Net drivers that I tried worked fine. Both drivers...
  • Blog Post: SQL Native Client 10 - provider name change

    The provider name for SQL Native Client (SNAC) connections has changed in Katmai. Since this is the default provider for OLEDB connections, you'll probably be affected by this change if you're running SQL Server 2005 packages in Katmai. Version Provider name SQL Server 2005 (Yukon) SQLNCLI.1 SQL Server...
  • Blog Post: SSIS connectivity white paper

    A connectivity white paper writen by Bob Beauchemin has been added to the connectivity wiki site . Definitely worth checking out.
Page 1 of 1 (17 items)