Thankyou Igor, trigger_nestlevel is what I was after, I have seen this used elsewhere but got it confused with @@nestlevel.

Thankyou for your reply.

The application uses SqlCommand to do the updates, I was thinking that the @@nestlevel was somehow more than 1.

Is there anyway to cover this, should I set...

Thankyou Chris, that was giving me a headache.

It seems that for large excel files, some temporary folders are created on an additional folder, which needs read write permissions. The folder is

C:\Users\Default\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.MSO

Cause on my...

Error message is not very helpful since Sheet1 does exist and is opened successfully when less than 25000 odd rows..

"Opening a rowset for "Sheet1$" failed. Check that the object exists...

They is no flag as such but there is a default team which if they belong to two teams is not their main team.

What I did was write two select...

Thanks for the help

Within my Main function I have:

DTSDestination("TerminalConfigurationFlagArray")= Hex(0)

Basically I need to initialise the Flag Array to be a binary - 0

I think the question has been written incorrectly.

Thanks that worked!!

Thank you all