Thanks, I put in the double quotes and it worked fine.

When I try to use the following as an expression I get the this error:

right('0000000000' + ConsultantID, 10)

TITLE: Microsoft Visual Studio

------------------------------

Error at Data Flow Task [Pad Zeros to ConsultantID...

Then again the value coming through will have different numbers eg. 123 needs to be 0000123 or 4567 needs to be 0004567.

Perfect. Thanks.

Seems to be working now. Maybe I was not patient enough.

Thanks

Your the man. It worked like a champ.

I have posted several times and it says that it did it but nothing appears in the thread.:cool:

Is this posting?

Not quite what I am after. I need the field name and field value for each:

[AdditionalFields]

[DateTimeField FieldName="ActivatedDate"]

[FieldValue IsNull="false" DateTimeValue="1999-03-25T00:00:00-05:00" /]

[/DateTimeField]

[DateTimeField FieldName="ConsultantPromDt"]

[FieldValue IsNull="false" DateTimeValue="1999-03-25T00:00:00-05:00" /]

[/DateTimeField]

[DateTimeField FieldName="ContractReceive"]

[FieldValue IsNull="false" DateTimeValue="2000-06-23T09:56:42-05:00" /]

[/DateTimeField]

[ DateTimeField FieldName="DeactivateDt"]

[FieldValue...

Not quite:

I need a single column for each field name containing its' appropriate fieldvalue:

[AdditionalFields]

[DateTimeField FieldName="ActivatedDate"]

[FieldValue IsNull="false" DateTimeValue="1999-03-25T00:00:00-05:00" /]

[/DateTimeField]

[DateTimeField FieldName="ConsultantPromDt"]

[FieldValue IsNull="false" DateTimeValue="1999-03-25T00:00:00-05:00" /]

[/DateTimeField]

[DateTimeField FieldName="ContractReceive"]

[FieldValue IsNull="false" DateTimeValue="2000-06-23T09:56:42-05:00" /]

[/DateTimeField]

[ DateTimeField FieldName="DeactivateDt"]

[FieldValue IsNull="false" DateTimeValue="2002-01-01T00:00:00-06:00"...

Not quite what I am after. That give me two fields. FieldName and FieldValue what I need

is let say the fieldname is ActivatedDate and the FieldValue is "1999-03-25T00:00:00-05:00"

I need one...

But not quite:

[AdditionalFields]

[DateTimeField FieldName="ActivatedDate"]

[FieldValue IsNull="false" DateTimeValue="1999-03-25T00:00:00-05:00" /]

[/DateTimeField]

[DateTimeField FieldName="ConsultantPromDt"]

[FieldValue IsNull="false" DateTimeValue="1999-03-25T00:00:00-05:00"...

Thanks. I knew I was close but you help push over the edge. I think it's coming together. 😛

Last question:

How would you address this?

[IsWithinCityLimits FieldName="IsWithinCityLimits"]

[FieldValue>true[/FieldValue]

[/IsWithinCityLimits]

All I need from this is the FieldValue.

OK I don't quite have it:

r.value('(n1:BusinessEntityAddresses/n1:BusinessEntityAddress/n1:State/n1:StateCode)[1]','varchar(30)') as StateCode,

[State StateCode="IN"]

[StateGuid IsNull="false DecimalValue="23567725519222135717227012983" /]

[/State]

This is returning nulls.