Unique Identifier Flat File Import with SSIS

David Justice — Fri, 07 Nov 2008 16:44:00 GMT

This morning I found myself wrestling with SSIS to convert a string from a flat file to a unique identifier via a Data Flow inside of an SSIS package. I figured this would be a rather trivial case (the midget was kicking my ass!). I use guids all over for application development and for database keys. They are very useful, and very dependable. Here is a line from my flat file:

61898d4c-3a1b-4736-9a36-eb90a23322e0|:|10/13/2008 11:59:58 PM|:|74afebfe-9523-4977-b5f6-5154b6c91211

Anyone see anything wrong with this? I didn't see anything wrong, outside of the silly |:| delimiter (I don't want to get started on that <rant/> <--- rant with no content!).

...(read more)

I Can't Believe That Worked! : GUID

Unique Identifier Flat File Import with SSIS