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

Presenting at PASS AppDev Virtual Chapter

Join me next Tuesday, December 14th at 11:00am CST as I present a webcast on behalf of the PASS AppDev Virtual Chapter.  I’ll be presenting “Dynamic SSIS with Expressions and Configurations”, where I show you how to remove static elements (such as connection strings, file names, and other transient values) from your packages and placing them in easier-to-administer configurations or…


No Picture

SSIS: Conditional File Processing in a ForEach Loop

I’ve fielded a number of requests recently asking how to interrogate a file within SSIS and change the processing rules based on the metadata of said file.  A recent forum poster specifically asked about using the foreach loop to iterate through the files in a directory and, on a per-file basis, either process the file or skip the file if…


No Picture

Book Review – SQL Server Integration Services: Problem – Design – Solution

I usually don’t do book reviews (at least publicly, anyway), but when I find a piece of work that I really get a lot out of, I don’t mind sharing my experience. Such was the case with a book I finished recently. SQL Server 2008 Integration Services: Problem – Design – Solution is a concise guide to becoming a better…


No Picture

An Un-CATCHable Error?

I’ve been using the scripting tools in SSIS for some time, but I came across something today that I can’t quite explain.  I normally don’t posts unresolved problems on my blog, but I’m trying out a strategy suggested by my friend Lee Everest by sharing unfinished work in the hopes that my research and troubleshooting can help someone else. So…


No Picture

Alpha Split in SSIS, Redux

So I’ve discovered another benefit of being a technical blogger.  Not only do you get some kudos when you write something that helps someone else, but if you offer up a less-than-optimal solution, you’ll get some suggestions on how it can be done better.  I’ve had my share of the former, but earlier this week I experienced the latter. Last…


No Picture

SSIS Alpha Splits using the CODEPOINT() Function

A relatively common requirement in ETL processing is to break records into disparate outputs based on an alphabetical split on a range of letters.  A practical example of this would be a work queue for collections staff based on last name; records would be pulled from a common source and then separated into multiple outputs based on a the Customer…


No Picture

LEFT(), or Left Out?

So the question came up earlier today about the RIGHT() and LEFT() functions in the SSIS expression language.  Like the Transact-SQL functions, one might assume that these functions would exist in SSIS expression language to snatch a specified subset of a string.  That assumption would be only half right. Don’t go digging for a LEFT() function in the expression language,…


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…