Thanks guys for your assistance. Very helpful.

I will get to work today, and put your suggestions into action.

regards

Kevin

Thanks for the script - very useful.

cheers

Hi Elliot

Thanks for your concern. I had simplified things a little in my original post. The data is actually sitting in different databases, and the source table is...

Thanks for all your responses.

Comments are acknowledged, and I have picked up a few great tips. This has been very useful.

regards

K

Thanks for the responses.

I was getting a little lost in the tools that SSIS has to offer, and was looking for an answer that was more complicated than it needed...

Hi Lutz, Jeff

Thanks very much for your help.

You have introduced me to some new concepts and techniques.

I will give it a go, and see how it pans out.

Thanks again.

K

Hi Lutz

3 example records to be filtered:

64112358 and 65888999

64199855 & 88859975 & 65889972

there are 4984118 and X4481566 and 69982214

--------

The expected results are:

64112358, 65888999

64199855, 65889972

69982214

---------

Any help with the above examples...

Hi Jeff

It is a varchar field of length 90.

regards

K

Problem solved.

Had to play around with the service accounts. and that resolved it.

Hi Gift

Thanks for your help. I had been doing what you were suggesting and it just wasn't working for me. Have had to do a fresh install, and...

Hi Gift

Thanks for your prompt reply.

I have been able to use the ACE driver to allow me to use Excel as a datasource to populate my table.

However, what I am...