Tim Mitchell
Follow Tim Mitchell on Twitter  Like Tim Mitchell on Facebook  Subscribe on YouTube  Connect on LinkedIn  Subscribe to the Data Geek Newsletter

SSIS

No Picture

PASS DBA Virtual Chapter Presentation

I got the opportunity to present to the PASS DBA Virtual Chapter today, discussing the properties and practical uses of SSIS expressions and package configurations.  Thanks to Greg Larsen and the other members of this virtual chapter for allowing me to present.  We had a good turnout, about 40 people, which is not bad for a lunchtime presentation. I’ve published…


No Picture

Webcast Tomorrow – Dynamic SSIS: Using Expressions and Configurations

Join me tomorrow at 1:00pm CST as I present “Dynamic SSIS: Using Expressions and Configurations” for the PASS DBA virtual chapter: In this session, we’ll review the use of expressions and configurations that can help make your SSIS packages more dynamic and flexible. We’ll cover the basics of the SSIS expression language and will demonstrate some practical uses, and will…


No Picture

Upcoming Speaking Engagements for December 2009

Next week, I have the honor of presenting two different sessions on SSIS.  These 2 events are the last speaking engagements on my calendar for this year: On Monday, December 14 at 11:30 CST, I’m presenting a SQL Lunch session to discuss looping logic in SSIS using the For Loop and the For Each Loop.  This will be a working…


No Picture

Eliminating Empty Output Files in SSIS

So you’ve got some packages that regularly extract data to one or more text files, but you know that from time to time some of the queries will not return any data. However, you find in SSIS that, in a flat file export package, the output file is created regardless of whether any rows are written to the file, and…


Space Sensitivity in SSIS Lookups

Space Sensitivity in SSIS Lookups

It has been well-documented through myriad blogs and forum posts about the case sensitivity of the comparisons in the SSIS lookup transformation (a good review can be found here). In a nutshell, a comparison using the lookup transformation is case sensitive when using the default setting of Full Cache, even if the values in the database are stored in a case…


No Picture

Upcoming Speaking Engagements for Q4

In the next few months, I’ll be giving a couple of talks on SQL Server business intelligence.  For October, I have the pleasure of presenting for SQL Lunch, a new online learning series pioneered by Patrick LeBlanc.  On October 12th, I’ll be discussing ways to leverage SQL Server Report Builder 2.0 against your existing SSRS infrastructure to allow users to…


No Picture

Skipping Items in a Foreach Loop

Recently, my friend Jack Corbett asked a question on Twitter: In a nutshell, the SSIS foreach loop will enumerate a given list of items (files in a directory, nodes in an XML file, static list of values, etc.) and will perform some operation for each of the items in the collection.  This behavior is similar to foreach loop constructs that…


Updating Data with SSIS

Updating Data with SSIS

Working with an ETL design that does a straight insert operation is the most simple, but often ETL processes are required to update data as well. There are several ways to go about updating data with SSIS, one of which (the staging table method) requires a bit more setup but can also perform significantly better. Updating Data with SSIS I…


No Picture

Don’t Use USE (in SSIS, at least)

I ran into a situation this week that brought to light a subtle syntactical error I’d made in creating an SSIS package.  I’ve got a client that has given me access to their development server to create some complex extraction queries, which will eventually be rolled into SSIS packages.  Since I’m working with read-only access and cannot create stored procedures…


No Picture

SSIS Documentation suggestions on Microsoft Connect

For SSIS developers, the need for proper documentation is crucial.  However, the built-in object for documentation, the annotation, is difficult to use.  It doesn’t wrap text, doesn’t support varying font styles in a single instance, and doesn’t offer spell checking.  Further, all annotations are “at large” and are not attached to a particular object – they are associated with a…