Using configurations files in SSIS is a great way to change how your package will run from outside the development environment. One thing that I’ve always recommended when using files (I actually prefer to use config tables) is to have one file for each of the connection managers in the package. The reason I have always recommended this instead of one file for all your packages is because previously in SSIS 2005 and 2008 if you used one file for all your packages then you must include all the co...

Read More