I'm new to sql server and very naive, but I'll take a chance.
I've read about the Dynamic Properties Task and an initialization file (.ini). Will they do what you need? I'm guessing they're discussed in other books but I found them in Microsoft SQL Server 2000 DTS Step By Step, by Carl Rabeler, page 215+. Good luck.