Helpful information and examples on how to use SQL Server Integration Services.
We’ve been hard at work on the next version of SQL Server, and it’s (almost) time to start sharing some of exciting new functionality we’ve introduced to SSIS. Over the new few months (starting about the time the first public CTP drops), I expect you’ll see a lot new content appearing here, technet, and other MVP blogs out there (some of which are linked off this site). Some readers have even noticed that my recent postings have had screenshots that were obviously not made with the 2008 R2 version of the product. (Rounded corners?!? What the ….)
While I can’t talk about the new stuff quite yet, I thought I’d comment on some of the blog posts I’ve seen from MVPs about Connect issues that were recently resolved as “Fixed”. Yes, we do listen!
First, a bit about timelines – the Connect items I’m posting about today will be appearing in the first CTP, but the vast majority of the recently closed issues will appear later in the release. It’s unfortunate that it sometimes takes so long for fixes to roll out into the CTP process, but I think it highlights how important it is to get your CTP feedback in as early as possible.
Disclaimer: The features described below relate to an unreleased version of SQL Server. The functionality in the final released version of the product may be different, or removed entirely.
Enable Undo in SSIS package designer
Yes, the SSIS designer will now have full Undo/Redo support. This encompasses pretty much every change that can be made in the BIDS designer - properties, add/remove tasks/components, copy & paste, layout, etc. To get this feature in, we also improved the Copy & Paste mechanism. The behavior is now more consistent, performs better, and covers more objects than it did before.
SSIS Data Flow "Sequence Container" Needed
The feature that went in isn’t quite a full scale Sequence Container for the data flow – it’s actually the same as the (little used) “Group” functionality in the Control Flow. Grouping a set of objects gives you the same layout behavior you get with a sequence container, without the execution semantics. So for example, you can expand/collapse the group, and move the components around together, but it is purely a layout feature. It does not affect the execution of your package.
Add "Input Dependency" Directives to Component Inputs
This “Improved Backpressure” functionality allows data flow transforms with multiple inputs to signal when they are getting too much data coming in on one input, and need more on another. The classic example here is for Merge Join – imagine the Left input is receiving a lot of buffers (due to a fast source component), but the Right input hasn’t received any yet (due to a slow source, or lack of available engine threads). Prior to this change, the source of the Right input would continue to produce new buffers of data until the backpressure mechanism detects there are too many active buffers. Now, the component itself can tell the data flow that it needs more data on its Left input, so the pipeline can put the source to sleep sooner.
SSIS: Custom Component Toolbox Installer
Our implementation is maybe not quite what the original Connect issue had in mind – we’ve actually added a brand new custom toolbox window. It loads faster than the previous (built-in) toolbox, and will automatically locate new tasks and components after they have been installed. There are built-in groups which allow you to organize your favorite, common, and lesser used components, as well as a handy panel at the bottom which displays information about the selected item with a link to a help topic.
If there are any other connect items you’d like details about, please let me know!
Thanks for the updates Matt! I'm looking forward to kicking the tires and taking it for a spin.
Looking good! Any chance we can get a target time frame before we see CTP? :-D
Sorry, can't say :) I wouldn't want to ruin the surprise.
Any news on separating code and layout, so we can use source control meaningfully and not like a binary store?
Dmitriy - I know this is something being considered, but it won't be in the first CTP, so I can't comment it on it yet. If you have specific scenarios in mind, email them to me (through the blog) or open new issues on Connect so we can review them.
Any chance you have added debugging to Script Components? It is a major pain without it.
Will this allow us to work with SSIS in VS 2010?
@jpinola - It's a feature I'd really like to see, but I don't think it's scheduled for this release. There is an old connect issue for (connect.microsoft.com/.../cannot-debug-script-component), but it might be worthwhile opening a new one. Include the scenarios that are blocked by not having this functionality, and/or the hoops you have to go through to workaround the problem. I can't guarentee that it would be accepted (I seem to remember there being quite a bit of work involved), but it would get my vote.
@Dean - VS2010 support will be added at some point, but it won't be in the first CTP. Right now we're working on a solution for IS, AS and RS BIDS designers that will (hopefully) be forwards-compatibile with future versions of visual studio.
I there any chance with the new release of not having to check out a package if I just want to look at it,
and a diff/compare making any sense for a normal developer?
Maybe using ID's instead of GUID's all over the place would help.
Designers for HTML, XAML etc, etc seem to work just fine with ID's.
Hi Marcel - Yes, improving the "multi-developer" experience is one of our goals in the next release. Unfortunately, it's still too early for me to talk about them at this point.