I've started to give this a go this afternoon, however, I've ran into problems creating the data flow diagram.

When I click on the data type box on for one of the output columns the script compoment just closes and will not let me change anything! - I'm trying to change it to DT_STR length of 10, as specified in the article.

I'll admit I'm a newbie to SSIS, so I did some reading before attempting this, but essentially this is my first SSIS project.

Can anyone give me some guidance, or point me in the direction of the correct forum area if this is not it...

My use of it is to standardise jobtitles for the record...