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!).
...