I have run into this and worked around it in a couple of different ways. Both worked.

First, you can specify a filter on a subscription. So, include a...

It is hard to say what you should be considering without knowing what you system will be doing.

On the Identity / GUID issue, there is now a sequential GUID function...

No, in your scenario, ServerA could sinply be a file server with a DTSX file sitting on it. Other than being the source of the definition of the package,...

Connection pooling is somewhat global - look in the "ODBC Data Source Administrator" (yes, go here if you are using the OLEDB Driver) and check the settings on the "Connection...

No, but you may be able to handle the additional permissions assignment with a DDL trigger.

The server (or file system location) a package is stored in does not impact the execution of the package unless it is really, really big. The only impact it...

I guess I would first ask why a dormant connection is causing an issue. They should not interfere with anything on the SQL Server end.

Moving on...

Dormant connections are usually...

xp_smtp_sendmail is not a system extended stored procedure that comes with SQL Server.

I think it is a third-party product that you need to install.

Why wouldn't you use database mail (which...

We did not delete the session data when the user exited. At first we wanted to, but we really had a lot of trouble getting accurate information from IIS...

Keep your database in the shallow end of the pool.

Use the FTP task to pull the files locally.

As far as the actual question, having a procedure keep it's execution plan is going to be bad for you since you have a 1 in 31 chance that you...

You can use a string variable as the sourceSQL of your data flow component. Make the string variable an expression and paste together the table number your are on...

Your goal should be to normalize the data. If you have to keep your child records and search temrs in sync (trigger or another method) you end up essentially...

Good point Shaun - there are worse solutions like the one you are talking about.

The original description did not sound like the plan was to use multi-value delimited fields. ...