In my last blog post Introduction to SSIS Projects in Denali I talked about the new Project deployment model that is coming in the next version of SQL Server Integration Services (SSIS); working hand-in-hand with Projects is another new feature – Parameters. Parameters are similar to Variables in SSIS today that we all know and (ahem) love but ...

The next version of SQL Server has been unveiled and it has a codename of Denali (aka SQL11, not aka SQL2011). SQL Server Integration Services (SSIS) is receiving quite an overhaul in Denali and over the next few days I’m going to outline some of the changes. Today? Projects! In SSIS today (i.e. prior to Denali) we build these things called SSIS ...

Todd Mcdermid spoke recently on his blog post Integration Services vNext Coming Soon about how some recently closed Connect items had encouraged him as to the future of SSIS. Also, Matt Masson from the SSIS team has written a similarly encouraging blog post about some upcoming SSIS enhancements at Upcoming Product Changes. Now its my turn. Just ...