• Great article.  I'm glad that I am not the only one who is missing these features.  I especially miss the ability to DTS objects, such as SPs, from one db to another.  That feature is now completely gone in SSIS!  I don't see any reason why MS should not add it back in sp1.

    Please MS, give us an easy way to script or copy stored procedures because some organizations rely on low tech admins to perform such tasks.  It used to be available in the SQL 2000 DTS wizard and was called "Copy Objects and Data Between Servers" but now that functionality is completely gone in SSIS.  It supposedly can still be done by creating a SSIS project in Visual Studio but that is too much for your average admin.

    You're right, I think Advil's stock is going to go up as a direct result of this.