Thanks a lot Marie. That was so informative.

How should I handle when we deploy the packages from dev to another environment. Any best practices in that area. I have heard of ssisdb. Do I need to worry about it? Or can i use import to msdb folder and schedule using sql agent.

It would be great if you could provide some details on template to set up for new environments.