It's the start of June, and for the past few years that has meant SQL Saturday in Pensacola, FL. For some reason, this year it's not the first Saturday in June, but the second one: June 9, right before TechEd North America 2012. I am scheduled to deliver two sessions at the event. 2:00 PM: … Continue reading SQL Saturday #132 in Pensacola, FL Around the Corner
Month: May 2012
A frequently seen question related to editing SSIS packages for 2012 is related to the SQL Server Data Tools (SSDT). SSDT is the successor to the former BIDS and to the former VSDB. However, even though Microsoft likes to think of SSDT as a single product rolling up the functionality of BIDS and VSDB, there … Continue reading When SSDT is not SSDT
In a previous post, I wrote about using SSIS 2008 custom components in SSIS 2012. In that post, I noted that the custom component's UI (Edit, Advanced Edit) does not work in SSDT. It turns out there is a way to get some UI for some components to work though. The key is that the component's … Continue reading Editing SSIS 2008 Custom Component Properties in SSDT
Disclaimer: I think this post will probably be more of a "memo to self" than be widely useful, but I wanted to jot down how I go about setting up my presentation environment, beyond just the basics. First of all, I go through quite some lengths to set up an environment like this, so there … Continue reading Setting Up a Virtualized Demo Environment
Update: 2012-05-07: Apparently, this method does work for SSIS 2005 tasks. However, these extensions should not use the native interfaces. Thanks to Matt Masson for the correction. For the next few weeks, the topic of upgrading SSIS 2008 packages to SSIS 2012 will be keeping me very busy. I am preparing to speak on the topic three times … Continue reading Using SSIS 2008 Components in SQL Server Data Tools with SSIS 2012
Sven Aelterman 