You can simply edit the config file and add the values or tweak the connection string in about any way you want.

Depending on how you setup package configurations depends on...

Sorry, I was otherwise occupied.. But opc.three's approach is fine as well and I agree with the points about the table naming.

CEWII

Yes. It isn't going give you passwords. That would be a major security breach.

CEWII

Oh Jeff you kill me man.. I have had way to many bad experiences with sp_OA methods, especially with in-process objects. out-of-process is still bad but not quite...

Yes you can. I would probably query the list of tables in an EXEC SQL task and use the full resultset option and write the output to an object...

That sounds right, it won't write out a password when the config file is created, the other file must have had it entered or it was contained in a variable...

That isn't the recommended configuration for three nodes. I believe Node Majority is the recommended setup. Either way if you lose two nodes the cluster is down..

CEWII

How often will they be accessed?

If the number is fairly small I probably wouldn't use FILESTREAM..

CEWII

I agree with GSquared, I can't think of any case where chunking them up would be beneficial and see LOTS of downsides. How big do you think this is...

I can't under ANY circumstances endorse an sp_OA method to doing this. As a matter of fact I'm of the opinion that those should not be used anymore under...

That is correct, you don't run the add node process on that node then it cannot under ANY circumstances ever run on that node.

I however would recommend not doing this....

None that I know of but you do need to be aware of Poison messages.

CEWII

Did you start notepad or whatever you were using to edit it AS administrator? You might BE an administrator but that doesn't mean that bit is flipped for the...

You are welcome.

CEWII

No, it can't per se.. The calls are synchronous and there is no flag or option to change that. However, you could use Service Broker with an auto...