by Allan Mitchell
5 Jan 2010 18:34
Tony Rogerson and myself are going to be in Dundee (we are going back to school) week beginning 18.1.2010. Whilst there we are going to do a User Group meeting and it would be great to see people there. More details can be found here - http://sqlserverfaq.com?eid=211
by Allan Mitchell
8 Dec 2009 06:46
The Script Task and Script component are often used by people developing SSIS packages because they are easy to use and now because SSIS could be perceived to be more developer friendly they are very powerful. That being said we should no be using them everywhere. There are generally Tasks/Co...
[More]
by Allan Mitchell
12 Sep 2009 07:37
I am going to be doing a webinar with our friends at Attunity on Change Data Capture. Attunity have a good story around this technology and you can use it in your SSIS loads to great effect. Join Attunity and Konesans/SQLIS for a Webinar on 17 September Space is limited. Reserve your...
[More]
by Allan Mitchell
21 Aug 2009 13:34
I am going to be speaking at the first ever SQL Server Saturday in Switzerland this autumn. This event is taking place on Saturday 19th September in Zurich. If you want to know more about it or are thinking of coming then head over to www.sqlsaturday.ch Charley has lined up a top list ...
[More]
by Allan Mitchell
11 Aug 2009 16:01
In July I was invited to speak at the UK SQL Server UG event in Manchester. I spoke about Excel being a good data mining client. I was a little rushed at the end as Chris Testa-ONeill told me I had only 5 minutes to go when I had only been talking for 10 minutes. Apparently I hav...
[More]
by Allan Mitchell
11 Aug 2009 13:36
What do medieval archaeology, fish farming, Southwestern University of Chongqing and Microsoft Business Intelligence have in common? If you know, you should tell Donald Farmer, because he has been deeply involved in all of them at various times. Donald has worked in the Microsoft Business Intelligen...
[More]
by Darren Green
3 Aug 2009 09:20
Sometimes when working with SSIS you need to add or change settings in the .NET application configuration file, which can be a bit confusing when you are building a SSIS package not an application. First of all lets review a couple of examples where you may need to do this. You are using referen...
[More]
by Darren Green
17 Jul 2009 16:07
In my previous post Searching for tasks with code you can see how to explore the control flow side of packages, drilling down through containers, task, and event handlers, but it didn’t cover the data flow. I recently saw a post on the MSDN forum asking how to edit an existing package programmatical...
[More]
by Darren Green
10 Jul 2009 12:19
I stumbled across a new SSIS tool on Codeplex today, the SSIS Log Analyzer which was only released a few days ago. Whilst it is a beta release and currently only supports 2005 (2008 is promised) it looks quite interesting. It seems to be a fancy log viewer, but with some clever features and a nice l...
[More]
by Darren Green
2 Jul 2009 18:14
This post shows you how to download files from a web site whilst really making the most of the SSIS objects that are available. There is no task to do this, so we have to use the Script Task and some simple VB.NET or C# (if you have SQL Server 2008) code. Very often I see suggestions about how to us...
[More]
by Darren Green
10 Jun 2009 21:44
If you some of the dynamic features of SSIS such as package configurations or property expressions then sometimes trying to work out were your connections are pointing can be a bit confusing. You will work out in the end but it can be useful to explicitly log this information so that when things go ...
[More]
by Allan Mitchell
9 Jun 2009 08:23
I recently gave a live meeting presentation to the UK User Group on Integrating Data Mining into your BI Solution. In it I talk about and demo ways of using your data mining models inside Integration Services, Analysis Services and Reporting Services. This is the first in a series of pre...
[More]