ProperCase() script to use in the dataflow

Does anyone have a nice script that can "Propercase" the values of a column in the dataflow. I was thinking of a Transform Script Task, with a Input and Output Column, which can be transformed.

With Propercase i think:

STEVEN SPIELBERG becomming Steven Spielberg

Maybe also with some exceptions soo that "DELIVERY EU" stays "Delivery EU"

you can use the following within a script to convert to proper case.

Row.Name = StrConv(Row.Name, vbProperCase)

You could setup some select case statements for exceptions...

Frank

sql

Programmatically Create a Lookup Transform

Hi,

i'm creating a Lookup programmatically. But i can't find out how to assign the ConnectionManager that references the lookup data.
Do you have an example for me?

Many thanks in advance.
Stefan L.

Use the RuntimeConnectionCollection of the component (IDTSComponentMetaData90). This is the same pattern as a you use for a source or destination, but any component can specifyc runtime connections, as indeed the lookup does.

component.RuntimeConnectionCollection[0].ConnectionManager = DtsConvert.ToConnectionManager90(package.Connections[0]);

|||Hi,

Great! It works! Thank you very much!

Stefan L.
|||

I am new to SSIS programming and having trouble using JoinToReferenceColumns (

http://msdn2.microsoft.com/en-us/library/ms136014.aspx#lookup ) property of lookup transformation. Can you please post a code sample?

Programmatically Create a Lookup Transform

Hi,

i'm creating a Lookup programmatically. But i can't find out how to assign the ConnectionManager that references the lookup data.
Do you have an example for me?

Many thanks in advance.
Stefan L.

Use the RuntimeConnectionCollection of the component (IDTSComponentMetaData90). This is the same pattern as a you use for a source or destination, but any component can specifyc runtime connections, as indeed the lookup does.

component.RuntimeConnectionCollection[0].ConnectionManager = DtsConvert.ToConnectionManager90(package.Connections[0]);

|||Hi,

Great! It works! Thank you very much!

Stefan L.|||

I am new to SSIS programming and having trouble using JoinToReferenceColumns (

http://msdn2.microsoft.com/en-us/library/ms136014.aspx#lookup ) property of lookup transformation. Can you please post a code sample?