Downloading a file over HTTP the SSIS way

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]

Currently rated 5.0 by 1 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags, ,

CategoriesScripting

E-mail E-mail |
Permalink | Comments (0) | Post RSSRSS comment feed

Logging connection strings

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]

Currently rated 1.4 by 5 people

  • Currently 1.4/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags, , ,

CategoriesScripting

E-mail E-mail |
Permalink | Comments (0) | Post RSSRSS comment feed

Integrating Data Mining into your BI Solution (Presentation)

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]

Currently rated 5.0 by 4 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags, ,

CategoriesData Mining | Presentations | User Group

E-mail E-mail |
Permalink | Comments (0) | Post RSSRSS comment feed

SSIS Tips & Tricks (Presentation)

by Darren Green 21 May 2009 09:01
This has been a rather well used presentation title but it does allow a certain degree of flexibility, and we covered a good range of topics in my session at the UK SQL Server User Group in Cambridge last night. Thanks to all who attended. Here is the rather limited slide deck and the all important... [More]

Currently rated 3.4 by 5 people

  • Currently 3.4/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags,

CategoriesPresentations | User Group

E-mail E-mail |
Permalink | Comments (1) | Post RSSRSS comment feed

Creating packages in code – Execute SQL Task

by Darren Green 19 May 2009 08:30
The Execute SQL Task is for obvious reasons very well used, so I thought if you are building packages in code the chances are you will be using it. Using the task basic features of the task are quite straightforward, add the task and set some properties, just like any other. When you start interacti... [More]

Currently rated 3.3 by 3 people

  • Currently 3.333333/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags, , ,

CategoriesCode Development

E-mail E-mail |
Permalink | Comments (0) | Post RSSRSS comment feed

July SQL Server UG Event in Manchester

by Allan Mitchell 18 May 2009 16:18
I will be speaking at the SQL Server UK User Group event in Manchester on 16.07.2009.  I am going to be talking about data mining again and how it isn’t all statistics and people with PhDs from Oxford.  Come join me and the excellent Chris Testa-O’Neill.  More details and registration... [More]

Currently rated 5.0 by 1 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags, ,

CategoriesData Mining | Presentations | User Group

E-mail E-mail |
Permalink | Comments (0) | Post RSSRSS comment feed

UK SQL Server User Group Events (June)

by Allan Mitchell 13 May 2009 07:12
There are two events of note for the SQL Server User Group in June.  The first is a Live Meeting event with myself on 04.06.2009.  I am going to be looking at how to integrate Data Mining into your BI solution.  I will be looking at putting DM into SSIS, SSAS and SSRS.  It will... [More]

Currently rated 5.0 by 1 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags

CategoriesPresentations | User Group

E-mail E-mail |
Permalink | Comments (0) | Post RSSRSS comment feed

UK SQL Server User Group Event (May)

by Allan Mitchell 13 May 2009 07:02
Our very own Darren Green is speaking at a UK user group event in Cambridge (UK) on 20.05.2009.  He will be speaking on Integration Services.  Peter Blackburn will also be there and what he doesn’t know about SSRS isn’t worth knowing.  It promises to be a good night.  We would lo... [More]

Currently rated 5.0 by 1 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags

CategoriesUser Group | Presentations

E-mail E-mail |
Permalink | Comments (0) | Post RSSRSS comment feed

Searching for tasks with code – Executables and Event Handlers

by Darren Green 12 May 2009 09:40
Searching packages or just enumerating through all tasks is not quite as straightforward as it may first appear, mainly because of the way you can nest tasks within other containers. You can see this illustrated in the sample package below where I have used several sequence containers and loops. To ... [More]

Currently rated 3.0 by 2 people

  • Currently 3/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags, , , ,

CategoriesCode Development

E-mail E-mail |
Permalink | Comments (0) | Post RSSRSS comment feed

Maintaining packages with code - Adding a property expression programmatically

by Darren Green 7 May 2009 14:15
Every now and then I've come across scenarios where I need to update a lot of packages all in the same way. The usual scenario revolves around a group of packages all having been built off the same package template, and something needs to updated to keep up with new requirements, a new logging stand... [More]

Currently rated 3.8 by 4 people

  • Currently 3.75/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags, , ,

CategoriesCode Development

E-mail E-mail |
Permalink | Comments (0) | Post RSSRSS comment feed

Trace File Source Adapter

by Administrator 1 May 2009 08:40
The Trace File Source adapter is a useful addition to your SSIS toolbox.  It allows you to read 2005 and 2008 profiler traces stored as .trc files and read them into the Data Flow.  From there you can perform filtering and analysis using the power of SSIS. Example Usages Cache warmin... [More]

Currently rated 5.0 by 5 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags, , , , ,

CategoriesComponent Downloads | Data Flow | Sources

E-mail E-mail |
Permalink | Comments (1) | Post RSSRSS comment feed

Creating packages in code - Package Configurations

by Darren Green 2 Mar 2009 10:00
Continuing my theme of building various types of packages in code, this example shows how to building a package with package configurations. Incidentally it shows you how to add a variable, and a connection too. It covers the five most common configurations: Configuration File Indirect Conf... [More]

Currently rated 3.8 by 5 people

  • Currently 3.8/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags, , ,

CategoriesCode Development

E-mail E-mail |
Permalink | Comments (3) | Post RSSRSS comment feed

Welcome to SQLIS.com our free SQL Server Integration Services (SSIS) resource site.

MVP

RecentComments

Comment RSS