The book http://www.amazon.com/Professional-Server-Integration-Services-Programmer/dp/0764584359/ref=pd_bbs_sr_1/002-0350974-4600063?ie=UTF8&s=books&qid=1189622456&sr=8-1 covers it

> Is there a way that would allow ssis to ask the user the server name at the time of exection?
>
>I have 2 servers; serverA and ServerB. I often import/export data in both of these two servers. I do not have to have two ssis packages, I need a way that will allow the ssis to ask the user the server name when the package is run.