Thanks for the advice.

Can I just ask....

If I set this constraint, does it potentially prevent the entire package from running, or will components AFTER the one I wish to exclude...

Thanks very much! My package now executes immediately, rather than pausing before it starts. There is still a minor 10 second pause between packages, but this is much...

Thanks _BC.

I have reduced the lookup data by creating views that exclude records taht would never match.

This appears to have both prevents the errors, and reduced the total running time...

Thanks for the reply.

With smaller group it generally runs through. I am not likely to have more than 1000 records at a time coming through once this is in...

Hi _bc,

I believe that I was mistaken in my initial diagnosis.

I am currently testing a SSIS package that is going to be used to clean and deduplicate incoming data before...

Ok. What I have done is to add another Execute SQL task in SSIS as follows:

Update TABLE

Set NAME = NULL

where NAME NOT LIKE '%[0-9]%'

AND

...

Hello,

Thanks for your code.

Yes, I have tried it,and I have been trying to modify it to suit my purposes.

Your code is selecting the records that I want, but is not...

Hi All,

Many thanks for your attempts to assist me.

I am a little embarassed to have been given the link to posting etiquette. My apologies.

I didn't spend enough time structuring...

Hi Sasidhar

Thanks for your advice.

Unfortunately I don't have a full list of disallowed fields, only allowable ones!

Perhaps my oringal post was a little elongated. What I am looking...

I realise that this is drifting off topic somewhat, but can anyone help me to get around this?

I am wondering if there is a way of using the NULLIF function...

Done it. Sorry.. please ignore the question.

What I had failed to do was to set the ResultSet property to "Single Row".

Yes, I fear that you are correct.

Oh well... sometimes the hard way is the best way to learn!!

Thanks for your input John. I have changed my select statement to use the NULLIF only for strings, so am no longer effected by the problem.

I will bear your...

Hi there,

I am now going to demonstrate my lack of understanding on this NULLIF function but....

Today I discovered to my surprise (see!?!) that NULLIF(field,space(0)) not only removes spaces from my...

Thank you very much Vaibhav K T

That did the trick swiftly and accurately. It must have saved me hours.

:-):-)