Lee,

After you figure out how you will store your SSIS packages (store in SQL Server vs store as external files, if I am correct about the choice), I hope you...

Aurora,

I still don't understand how to have a centralized view and development scenario for our developers.  When I try to save an SSIS package using the Business Intelligence Studio, it...

Markus,

If you find out how to do this, I'd appreciate your posting the answer here, because that is one of my big problems with this conversion.

- Patrick

I would like to use the SQL Server Management Studio to schedule and otherwise manage packages stored in MSDB.  Using your method above, the BI Management Studio packages appear to be stored...

Jean-Luc,

I will be doing this using T-SQL in a DTS job, but your code and Chris's snippets will give me a start.

Thanks.

Patrick

Chris,

Is there any chance of getting a copy of your script?

- Patrick

Then again, I have just now finished correcting this error by rebuilding the offending table.  I had been getting this error on a test database that had a table using a computed column,...

I was glad to read Andy's argument -- it makes me feel better about our method. We use both WA and SQL logins: WA authorizes a person to get...