Blog - Title

March, 2012

  • SSIS Team Blog

    Bulk Loading Data to Oracle

    • 1 Comments
    In SQL Server 2005, and the non-Enterprise editions of SQL 2008/SQL 2008 R2, SSIS doesn't provide an out-of-the-box option for bulk loading Oracle data. Instead, SSIS components implement single row inserts to load data to Oracle. This can result in issues...
  • SSIS Team Blog

    CDC for Oracle in SQL Server 2012

    • 15 Comments
    One of the new features introduced in SQL Server 2012 is the ability to use SQL Server CDC for tracking changes on an Oracle table. In the following post you will understand how to setup such a service for tracking changes on your Oracle tables. Configuring...
  • SSIS Team Blog

    SSIS Catalog - Backup and Restore

    • 3 Comments
    Integration Services catalog (SSISDB) uses the encryption mechanism available in SQL Server to protect its sensitive data. So backup and restore of SSIS catalog across machines need some extra steps in addition to the usual backup and restore steps. This...
  • SSIS Team Blog

    SSIS Catalog Access Control Tips

    • 7 Comments
    SSIS 2012 introduces significant improvements in how SSIS packages are deployed, configured and managed in a centralized SSIS catalog. The SSIS catalog corresponds to a user database, called SSISDB. You can secure the SSIS objects in the SSIS catalog...
  • SSIS Team Blog

    Changing Variable Scope and other Enhancements

    • 3 Comments
    In SQL Server 2012, SSIS includes some very useful enhancements to package variables. You can now change the scope of an existing package variable. Just select the variable in the Variables window and click the new Move Variable icon. Then, in...
  • SSIS Team Blog

    SQL 2012 Connectors for Oracle & Teradata Coming Soon

    • 4 Comments
    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...
Page 1 of 1 (6 items)