Brian Kelley (blog | @kbriankelley) delivered an awesome and at times scary - no offense, Grant Fritchey (blog | @GFritchey) - presentation today on Security and SSIS. The recording is now available here. Enjoy! :{>

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

In his article Healthcare's Big Problem With Little Data, author Dan Munro raises salient points about the state of health-related data. Electronic Health Records (EHR) were promoted as the end-all-be-all solution for the industry – a standardization that, I suppose, many thought would organically and naturally occur, stabilize, and be ...

I recently stumbled across a nuance of the SSIS expression language which, when you think about, kinda make sense – but it does help to be aware of it. Its concerned with casting of datetime values using the SSIS expression language Take the following expression: (DT_WSTR,30) @[System::ContainerStartTime] That expression casts a datetime ...

This is something I’ve been meaning to blog about for ages but it kept slipping my mind, sorry about that! Wee Hyong Tok from the SSIS product team has built a slide deck that covers some of the deep secrets about SSIS2012 including: Catalog deep dive Security Low level monitoring and troubleshooting The slide deck is available to ...

I’ve just put out a new version of sp_ssiscatalog. The main change is requesting a list of executions using: exec sp_ssiscatalog @operation_type='execs' returns a new field called relative_duration: This length of the “bar” in that field represents the duration of that execution relative to all the other executions in ...

v1.0.2.0 – what’s in it? Things have been a bit quiet on the sp_ssiscatalog front since I last blogged about it three months ago in December 2012. Rest-assured development continues apace however and today I’m making available a minor update, v1.0.2.0 which is now available for download from Codeplex. For those that don’t know I describe ...

Today I was using a 3rd Party Data Flow component that has several Custom Properties for which I need to change some of their values at runtime using a DTS Expression. To mimic the situation let’s use the “Percentage Sampling” that has two Custom Properties: Of the two Custom Properties only some (one in this case) are available also outside ...

Want to learn more about SSIS? I  can help. In my course - From Zero To SSIS – I teach you how to effectively use SSIS to deliver data integration solutions. This is not a market-y survey of the bells and whistles contained in SSIS. I focus on the tasks data integration and ETL developers will use to produce SSIS packages in the enterprise. ...

In December 2012 Microsoft published a whitepaper entitled SSIS Operational and Tuning Guide which you can download by clicking here. I have skimmed through the whitepaper and it appears to be a compelling read however a couple of sentences caught my eye that I want to draw attention to here. These sentences refer to the use SSIS checkpoint ...