Really? I thought the third argument specified how many characters to use.

SUBSTRING(fieldname,start_position, number of characters)

I'll look into this.

An update:

I now have this functionality working in T-SQL.. bu tI would dearly LOVE to have the expression in the Derived Column do this job.

In T-SQL I am using the...

I have tried the following:

For Field 1 - SUBSTRING([RefNumber],1,1)

This correctly returns the first digit.

For Field 3 - SUBSTRING([RefNumber],FINDSTRING("/",[RefNumber],3),(FINDSTRING("$",[RefNumber],3)) - FINDSTRING("/",[RefNumber],3))

This is accepted by the Derived COlumn transformation, but when I...

Not at all. The issue I had was that it was allowing addresses though WITHOUT the .com on the end. ie text.text@gmail

Phils amendment to my expression now means that...

Phils method seems to be working fine. So far I haven't seen any invalid email addresses slipping though the net!

Thanks Phil!

Paul

Hi all,

Apologies for the delay in my feedback.

I revisited this today, and using the default value for the "create", and trigger for the "modified" this is now working perfectly.

Thanks again!

:-P:-P

Thanks for the reply.

When I create a table I simply state "references OTHERTABLE(Field)". Thus generating a seemingly random FK name.

I'll check out BOL.

Thanks again!

Thanks once again for the helpful responses. I will test this tomorrow.

I think I need two triggers (please correct me if I am wrong) becuase I would like the...

Brilliant Jack...

That did it!!

Thanks a lot.

Thanks for the advice.

The syntax that is in use here.. is it intended to be used is the Script Component, Derived Column or T-SQL? It doesn't quite work for...

I have now added a Execute SQL Task component after the data has been written to a table, where the unwanted dates are set to NULL.

Would still love to know...

This worked brilliantly. I completed the changes, and did some testing and all looked well, but it wasn't until some live data was sent through that contained the ampersand...

Thanks Tim. I will give it a try. I will be back to that particular project on Tuesday, so will update the thread then.

I haven't really found any useful articles on the use of Output Clauses to enable me to do this task. However I have been able to do it in...

Hi Tim,

Thanks for the advice. I have inserted your script task, and amended the text to call my variable, as both the read and write.

Unfortunately it returns this error:

Error...