MVP Davide Mauri creates SSIS Dashboard

For those SSIS customers looking to add a 3rd party dashboard to monitor their SSIS executions, fellow MVP Davide Mauri has written one that you can try out at no cost. Take a look here for more information: https://github.com/yorek/ssis-dashboard Davide also has a working demo: http://ssis-dashboard.azurewebsites.net/

Read more
SSIS vNext: Survey Opportunity to Shape the Future

If you’ve wanted to influence the future direction, now is the best chance to get your thoughts heard. Microsoft has a survey available for you to fill out, with which your feedback will be used to help shape the future of the product. Please fill it out, and use the comment boxes to fully capture […]

Read more
SSIS 2012 – Catalog Indexing Recommendations

2013-11-26 – UPDATE – SQL Server 2012 CU 7 -or- SQL Server 2012 SP1 CU4 addresses the indexing recommendations. See KB 2829948 for more details. I’ve been sitting on this content for about a year now, and due to external pressure (Thanks Matthew!) I’ve decided to put this into writing. One of the reasons I’ve […]

Read more
Connecting to a pre-SQL 2012 SSIS Instance with SQL 2012 SSMS

If you are using SQL Server Management Studio in SQL 2012 to try to connect to an older SSIS instance (SQL 2008 R2 and earlier) called “SSISServerName”, you will get an error: Connecting to the Integration Services service on the computer “SSISServerName” failed with the following error: “Class not registered”. This error can occur when […]

Read more
SSIS 2012 – SSIS Environment Variables String Limit

UPDATE: 2012-02-24 – The bug I submitted on this has been closed as “won’t fix.” I had asked the team to enforce this limitation in the GUI instead of throwing a somewhat cryptic error. Sorry. When creating environments in the new SSIS catalog, you are able to define environment variables. When creating string variables, you […]

Read more