An Elevator Pitch for Identity Management

Posted by on October 1, 2008 4 comments

It’s time to really launch this site and get blogging about Identity Management.  To get things started, I’m trying to come up with a good elevator pitch for Identity Management.  Too often I have to explain both what I do, and the industry I’m in.  No matter what I say, as soon as I’ve uttered the words “Identity Management”, folks assume I work for a company that helps prevent Identity Theft.

Any thoughts on a good pitch?  Put it in the comments.  I’ll post what I come up with on Friday (and I might even “borrow” from some of your comments).

SSIS: Reading and Writing Variables in SSIS Script Tasks

Posted by on October 26, 2007 No comments

Recently I was creating an SSIS script task that needed to read and write to variables. After doing some research, I found some code at this site which simplifies the task.

The code includes a function called ReadVariable which reads in the value of a variable, as well as subroutine called WriteVariable, which writes a value to a variable. I personally prefer using these routines, as you avoid having to configure the ReadOnlyVariables and ReadWriteVariables attributes of the script task, leaving everything in the code of the script.

SSIS: Returning NULL in a conditional statement

Posted by on October 22, 2007 1 comment

I was working with SSIS the other day, and was trying to get to use a Derived Column Transformation to return a NULL value. It should be pretty straightforward, however it seems you have to cast the NULL expression as a NULL value for it to work properly. Rather than using simply:

TRIM(column_name) == “NULL” ? NULL(DT_STR,27,1252) : TRIM(column_name)

I instead had to use:

TRIM(column_name) == “NULL” ? (DT_STR,27,1252)NULL(DT_STR,27,1252) : TRIM(column_name)

Thanks to this blog entry for pointing me in the right direction.

Welcome To My New Blog

Posted by on May 29, 2007 No comments

Welcome to my new blog. I plan on using this forum to share my research and technical experiences, specifically relating to Identity Management.

This replaces my old website, trachta.org, which I didn’t spend enough time updating.

Social Widgets powered by AB-WebLog.com.