Having the tenant_id in each table will not be a problem. You don't have to make it part of the clustered index, but since every query you run will...

There are several ways, but I would suggest you look into package configurations first.

They are well-documented in books online and there are plenty of articles available by searching google.

You should forget triggers and use service broker. It is designed for creating a queue and processing that queue as requests come in.

Which then brings me to the most...

The "Final Commit" it is referring to is the actual commit of the data in the table. So, you probably have an OLEDB Destination component doing your insert. ...

SQL Server 2005 does not know anything about the number of processors licensed unless you hit an edition limitation (which you have not). It certainly does not return wrong...

"Error Handling" is too broad of a term. You need to be more specific about what you are trying to do.

I'll start with the simple one. I would not use ID's from Sysindexes for figuring out objects. Use the object schema / name. If you use object...

The DELETE will only really take any additional performance hit if it has to wait for a resource lock. In you case, it may be that it has to...

I have not had this problem, but from the description, I would suspect it is a driver issue more than it is an SSIS issue. You should check for...

No, SQL Server does not "consistently" support the named parameters. That's why I bailed out on really using them.

As far an anything beyond the OLEDB Command in the data...

Use the OLEDB Command transformation like you have.

Make the SQLCommand something like:

UPDATE MyTable SET MyColumn=? WHERE MyID=?

When you get to the column mappings you will find that you can now...

It's fairly simple, actually.

You have two methods. The easiest way is to run the DTExec command line utility. This gives you the same abilities you have from the...

Ok, so your current planned model basically allows permissions to be set to basically permit or deny the execution of a stored procedure. So, rather than an AreaIndex, why...

With an SSIS solution, you should not have to use linked servers at all. You would use an OLEDB Source and an OLEDB driver for MySQL as the source...

Sorry, I was unclear. Yes, you can turn the IsSorted property on manually, but since that does not actually sort the data, you have told SSIS that the data...