I have 12 packages in my SSIS project to configure and deploy; what are the major things to change in these two processes to ensure smooth package preservation? Is it ok to select all properties in the 'Select Properties to Export' page?
I had configured and deployed a trial copy package and after that I tried running the package again but it failed; should that be expected? What If I want to run the package in future, is there anything I need to turn on or off on the configuration properties?
When I schedule sql server job, would this failure affect the job from executing?