Wouldn't it be nice if you could change DTS package properties at runtime? If you could then you could have a generic package that processed different files, loaded different database tables and/or connected to different servers, plus a slew of other things. In this article, Gregory Larsen discusses how to use the dynamic property task to set DTS package properties at runtime.

This story continues at http://databasejournal.com/features/...le.php/3559551