Thanks Jeff.

I took a look at your article, and can see that I will need to have a bit more tie on my hands to get my head around it!...

Thank you very much! That does the trick perfectly.

I see how it works too, which is good.

You have been a great help.

Hi Lowell,

Thanks for your reply. Yes, my columns are collated as Latin1_General_CI_AS.

Do you think that is the reason? Pity, because it looked like a useful function for our...

Oh of course. Yes it works, and I am happy with that. I doin't want to take up too much of anybody's time.

What is quite strange is that...

I have not been able to find a solution to this unfortunately.

It seems add that simply setting the RetainSameConnection to True would cause a permissions error.

Sorry about that. I have added some line breaks to try to make it easier to read.

Hi Brandie et al,

I have not encountered that errors again since increasing the size of my paging file. However today I tried to reconfigure my packages to use a...

Hi Phil,

Yes it does sound a little strange I know. Its a long story, but this is an application that is being used from now on as a "read...

Thanks for the reply, Brandie.

I have looked though many of the links to the google search for

SSIS A network-related or instance-specific error has occurred while establishing a connection to...

Thanks for that.

I had though that the memory would be released when each individual package finished running.

I could make package 1 re-run itself after package 2 has finished (which would...

As an aside... does anyone know whether SQL Server Agent will run the same job twice? The job mentioned above is scheduled to run every 5 minutes. If...

Both methods work perfectly - thank you!

I will use the one that you label as foolproof, to be safe.

Many thanks for your kind assistance.

Thanks very much for this. I have added the expressions and am now able to skip whole chunks of my package based on certain conditions which have been written...

No complaints at all.

10 seconds is perfect. To be honest there was also quite a significat delay before execution of th efirst package, and this has completely gone.

So...

I will give those a try!

Many thanks.