There's a chapter on building UI for SSIS packages in the book Professional SQL Server 2005 Integration Services (Programmer to Programmer)

> Is there a way that would allow me to design ssis package that would ask the user the server name for source and destination at run time?
>
>I need to create a parameter for OLE DB.
>
>Thanks
>
>MA