Would the actual connection strings go in the "ActualServer"  and "DummyServer" quotes?

John Mitchell or anybody, could you elaborate on this?

"If that doesn't work, you could set the connection string property with an expression that chooses one server at midday...

SSIS still tried to validate the connection even with DelayValidation set to true and no control flow or data flow calls to the connection.

Thom thanks for the visual!  It was what i needed.

Sorry my mistake!!!  I was not looking from the connection manager pane as you told me!   Once I did i found it and set it.  Thanks again everyone and...

There are only two properties visible
Full Name
Full Path

I am googling this now, I will let you know if i find out why the property is not...

Thanks everyone.  I should have mentioned this is a Native OLE DB/SQL Server Native Client 11.0 connection.  I don't see "DelayValidation" as an option in the designer.  Can i set...

I though of the tab possibility but when I use the ASCII() function there is no tab.

Thanks everyone for your responses. This sql was written by me but...

Nope. The problem seems to be that "two space name does not equal two space name" at least in the context of CASE expression. So that

if 'Diane...

Yes and it is not made clear on the Attunity site. It may be buried somewhere but I don't see it.

You got it Grasshopper! I guess I thought those bits would be wrapped up in the SSIS package. Once I installed them on the server I could deploy.

Now...