When: October 15, 2013 8:45 am - 4:45 pm Charlotte, NC Where: Wake Forest University Charlotte Center 200 North College Street Charlotte, NC 28202 What: Business Intelligence Markup Language (Biml) automates your BI patterns and eliminates the manual repetition that consumes most of your time. Come see why BI professionals ...

PASS Data Warehouse / Business Intelligence Virtual Chapter Co-ChairWeb: http://bi.sqlpass.org | Email: PASSDWBIVC@sqlpass.org | Twitter: @PASSBIVC  Friday February 22nd 11am EST(US)Hacking the SSIS 2012 CatalogSpeaker: Andy ...

I will be unveiling a shiny new presentation – Hacking the SSIS 2012 Catalog – at the SQL Server Innovators Guild in Greenville South Carolina 5 Feb 2013! The location of the meeting is: ECPI, Greenville, SC 1001 Keys Dr Greenville, SC 29615 If you will be in the area that evening and if you read this blog, stop by and introduce ...

Regular readers of my blog may know that over the last year I have made available a suite of SQL Server Reporting Services (SSRS) reports that provide visualisations of the data in the SQL Server Integration Services (SSIS) 2012 Catalog. Those reports are available at http://ssisreportingpack.codeplex.com. As I have built these reports and used ...

SSIS Reporting Pack is a suite of open source SQL Server Reporting Services (SSRS) reports that provide additional insight into the SQL Server Integration Services (SSIS) 2012 Catalog. You can read more about SSIS Reporting Pack here on my blog or had over to the home page for the project at http://ssisreportingpack.codeplex.com/. After having ...

I’ve been working on a SQL Server Integration Services (SSIS) solution for about 6 months now and I’ve learnt many many things that I intend to share on this blog just as soon as I get the time. Here’s a very short starter-for-ten… I’ve found the following query to be utterly invaluable when interrogating the SSIS Catalog to discover what is ...

My buddy Sutha Thiru sent me an email recently asking about my opinion on a particular nuance of the project deployment model in SQL Server Integration Services (SSIS) 2012 and I’d like to share my response as I think it warrants a wider discussion. Sutha asked: Jamie What is your take on this? ...

This is a heads-up for anyone doing development on SSIS. On my current project where we are implementing a SQL Server Integration Services (SSIS) 2012 solution we recently encountered a situation where we were unable to deploy any of our projects even though we had successfully deployed in the past. Any attempt to use the deployment wizard ...

Over the past year or so I have written at length about the SSIS Catalog that will be provided in the upcoming version of SQL Server Integration Services (SSIS 2012) and the capabilities that it will bring; one of the biggest benefits (in my opinion) is that logging is now something that is taken care of on your behalf. Many SSIS developers have ...

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 ...