Storing packages in SQL Server, or as structured storage files is not a big issue. An advantage for storing in SQL Server is that you can transfer packages between servers with a simple insert query.

The main thing is to structure/develop the package so it is configured dynamically. Without the dynamic configuration you're in for many dreary hours editing packages every time they a moved 😉