Post removed.

Why don't you use a Precedence Constraint to the alert task?

I'm not sure where your getting your values from but basically you want to do the following.

For the INSERT Perform an INSERT followed by a JOIN of all tables and...

You have 3 tables, A, B, C, D, and E? :hehe:

I'm sure that there is more to your Table Structure than you provided.

Please provide and click on the first link...

You should probably post in the SSIS Forum. 🙂

Do either of...

Duplicate post.

http://www.sqlservercentral.com/Forums/Topic1167066-148-1.aspx

Good points Craig.

With respect to the Standby Server you may want to consider documenting the connections strings that you changed when you consolidated so that if you need to move...

This is a self join exercise.

The manager name should be derived from the employee name column.

This is one example.

http://blog.sqlauthority.com/2010/07/08/sql-server-the-self-join-inner-join-and-outer-join/

😎

Scripts to rebuild the indexes.

http://blog.sqlauthority.com/2009/01/30/sql-server-2008-2005-rebuild-every-index-of-all-tables-of-database-rebuild-index-with-fillfactor/

http://www.mssqltips.com/sqlservertip/1367/sql-server-script-to-rebuild-all-indexes-for-all-tables-and-all-databases/

http://blogs.msdn.com/b/joaol/archive/2008/01/28/script-to-rebuild-and-reorganize-database-indexes-sql-server-2005.aspx

You should do as Gail suggested, Rebuild...

You can perform it in T-SQL.

RESTORE DATABASE DBName

FROM DISK = '\\Server\Share\Folder\BackupFile.bak'

WITH REPLACE

You can add the code to your SSIS Package.

I believe that the Potential Data Loss means that you are only going to get an accuracy of the DateTime in minutes as opposed to seconds.

Let me know if I can help.

Regards.

I would start out with a clean install.

You may want to try to install on a Home PC if you have not already done so.

I really don't care for Express....