One of the biggest complaints I see developers raising about SSIS since it was released in 2005 is that the only way to debug Script Components is the distinctly simplistic and old fashioned method of sticking up message boxes - there is no way to step through the code as it executes (something that Microsoft developers have ...

In December 2010 I announced in a blog post Introducing SSIS Reporting Pack for SQL Server code-named Denali that I planned to provide a series of reports that visualised information held in the SSIS Catalog in SQL Server Denali – I called these reports the SSIS Reporting Pack. At that time SSIS Reporting Pack was a precursor to what I really ...

In my blog post SSIS Server, Catalogs, Environments & Environment Variables in SSIS in Denali from November 2010 I alluded to forthcoming enhancements in the logging infrastructure when I said: One final note on logging. The fairly limited information that gets captured in the current CTP is not the same as what will be in the product upon ...

The third Community Technology Preview (CTP3) of SQL Server code-named Denali is upon us and, although you would never guess from the official announcement, there is a whole raft of enhancements to SQL Server Integration Services (SSIS) and in this blog post I will take you on a tour of some of them. I must stress that nothing here is finalised ...

Tomorrow I shall be presenting a webinar entitled “New SSIS features and enhancements in Denali”. The webinar is being hosted by Pragmatic Works and you can sign up for it at Pragmatic Works webinars. The webinar will start at 1930BST and you can view the time for your timezone at this link: ...

Earlier today I stumbled upon a blog post that I wrote back in 2008 entitled Absolute and relative paths where I said: A common complaint about SSIS is that it does not allow the use of relative paths. The most useful application of this feature would be the ability to execute packages (using the Execute Package Task) where all the ...

SQL Server Integration Services (SSIS) in its 2005 and 2008 incarnations expects you to set a property values within your package at runtime using Configurations. SSIS developers tend to have rather a lot of issues with SSIS configurations; in this blog post I am going to highlight one of those problems and how it has been alleviated in SQL Server ...

In recent blog posts I have introduced the new SSIS Catalog that is forthcoming in SQL Server Code-named Denali: What's new in SSIS in Denali Introduction to SSIS Projects in Denali Parameters in SSIS In Denali SSIS Server, Catalogs, Environments and Environment Variables in SSIS in Denali The SSIS Catalog is responsible for ...

This post relates to SQL Server code-named Denali which at the time of writing is a pre-release version of the next version of SQL Server. It is also known as SQL11 and is expected to be released sometime in 2011 or 2012. The name given to it on release is not yet known. Some of the information in this blog post may not be true upon ...

In the last few days I have written 3 blog posts covering some new features in SQL Server Integration Services (SSIS) in the next version of SQL Server, code-named Denali: Introduction to SSIS Project in Denali Parameters in SSIS in Denali The new Execute Package Task in Denali In this blog post I’m moving onto talking about the new ...