Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

30 April
2014
Author: ShawnHarrison

Intro to SSIS Webinar Follow-up

 

Thanks to all who attended yesterday?s webinar. Since I ran short on time and wasn?t able to answer any questions, here are all the questions and their answers.

 

<
18 October
2013
Author: ShawnHarrison

Scripting Webinar Follow Up

 

I would like to say thank you to all of those that attended my webinar on using C# scripts in SSIS. I had a lot of fun putting together examples for that presentation. There were a f

16 August
2013
Author: ShawnHarrison

Looping Through Variable Values with a ForEach Loop Container

Have you ever done something in SSIS that you wish you had a need to do more often? That happens to me on occasion. I have a tendency to test out random scenarios when I get bored. You read correct

22 July
2013
Author: ShawnHarrison

SSIS Best Practices Webinar: Follow Up Q&A

Last Thursday I presented a webinar on SSIS Best Practices and how BI xPress can analyze SSIS packages to ensure those practices are being followed. I got a lot of great questions, but couldn?t ans

30 November
2012
Author: ShawnHarrison

Looping Through Excel Files in SSIS

Let me start by saying that Excel makes for a horrible source. I have used SSIS packages to loop through files many times before, but never Excel (until recently). I know what you?re thinking. ?Gee

27 November
2012
Author: ShawnHarrison

SSIS 2012 Deployment Webinar: Follow up QA

I would like thank everyone who attended my webinar on SSIS 2012 Deployment Models. Since I can never expand the size of the question window in the webinar, I miss a lot of questions. For all those

04 October
2012
Author: ShawnHarrison

Disconnected Lookup in SSIS with Task Factory

One feature of Informatica that many people enjoy is the ability to do a ?disconnected lookup?. Now, thanks to the latest release of

18 June
2012
Author: ShawnHarrison

SSIS 2012 Project Deployment

There have been some rather significant changes made to SSIS in SQL Server 2012. One of which is package deployment. In 2005 and 2008, one could easily deploy packages to the MSDB. In 2012, this ha

08 March
2012
Author: ShawnHarrison

Performance Tuning SSIS Webinar Follow Up Part 2: Q & A

Hi Everyone! I have finally got around to answering all the questions from my performance tuning webinar from last week. I couldn?t answer all of them, since some of them were in fragments, but I g

06 March
2012
Author: ShawnHarrison

SSIS Performance Tuning Webinar Follow Up, Part 1

I want to say thank you to everyone that attended my webinar on SSIS performance tuning. I had a great time putting that presentation together. For those of you that didn?t see it, you can access i