ahh, missed the 1st one. I'll give that a go - thanks for clarifying

Sorry, I missed that off when I typed the code in, I do have that extra END datement in but I am getting an error

Great - thanks both I have never came across that option before.

I have found a way to do this. Ensure that your Log Package Execution to SQL Server found under Package > Properties and Logging.

Then use the following to run detailed...

Please post a reply if you find out - I have came on here looking for exactly the same answer to this problem!

Sure, here is a small cross section

Re Bill 177959 11/04/07

Re Bill 177959a 14/05/07

HMCS 54BNHDCQHATTONA~OP~HMCS - text written here (Re: 62637373739/89272)

HMCS #01BNHDCQpatteml~OP~HMCS - text written here (Re: 62637373739/89272)

HMCS #01BNHDCQCookeA~OP~HMCS – text...

Thanks all - I originally had the fields only the values as datatype int. I have now changed this to decimal(4,2).

Thanks Jeff

Thanks for the advice guys.

Gail, can I ask if you passed the exam? I'm assuming you find out there and then as you do with 70-431?

As for the book, sounds...

Great. Thanks - I knew there was a way

Thanks for your help all. I am going to use Sergiy's example. This will work as my completed date will always be on a weekday. If it was on a...

Thanks for all your help. I have it working perfectly now!

I'm just trying to create an endpoint for test purposes. I am going to connect to it using visual studio 2005.

Ok I have tested the function but it does return an error when the data exceeds 250 characters. What is the best way to get round this?

Use a convert function...

I changed the text datatype to a varchar(250) and it create the function.

If the data exceeds 250 I want to truncate the data as it will be used in...