CDC for Oracle in SQL Server 2012

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 your Oracle server Before creating the service, you must…


Changing Variable Scope and other Enhancements

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 the Select New Scope dialog box, select the package, or a package container, task, or event…

4

Script Component Debugging in SSIS 2012

In SQL Server 2012, you can now debug the Script component by setting breakpoints and running the package in SQL Server Data Tools (replaces BIDS) .   When the package execution enters the Script component, the VSTA IDE reopens and displays your code in read-only mode. After execution reaches your breakpoint, you can examine variable values and step…

18

SQL Server OLE DB Deprecation and Integration Services

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…

2

SSIS Team Now Hiring!

The SSIS team is now hiring developers! Would you like to be a key part of a successful team that is rapidly increasing its impact on the multi-billion dollar Data Integration market? Are you enthusiastic about data integration, transformation, performance and scalability? If so, come join the SQL Server Integration Services team. We are a…


Changing the Data Viewer font size

Did you know you could change the font size in a data viewer grid? If you’re like me and frequently demo SSIS on a big screen (or if you’re just tired of a 8 point font size), this is extremely handy. You can find the setting as a Visual Studio option: Tools –> Options… Environment…


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…


SSIS Team Blog – Now in Chinese

Xiaochen Wu, a member of our Shanghai team, has started a Chinese SSIS blog. He’s started it off by translating some of the posts I’ve done, and I’m sure he’ll find plenty of content in the future. I don’t know what the following text means, but I assume it’s the title of the blog 🙂…


Matthew Roche on RunAs Radio

Matthew recently did an interview for RunAs radio where he gives a really good overview of SSIS, DTS, and ETL in general. It’s great if you’re just getting started with SSIS, or need to sell someone else on the idea of using it!


SSIS sets an ETL world record

They mentioned the TPC benchmark results at the SQL Server 2008 launch today. The final paragraph mentions a world record for ETL load performance. The fine folks who maintain the SQLPerf blog have posted details about the result, explaining how they were able to load over 1 TB of TPC-H data in under 30 minutes….