ask user to select excel

Dear friends, can anyone please tell me that how at the time when user executes the package i can ask a user to choose the datasource excel sheet and what are the constraints i have to take care of in the integration package desing.

thanks,

If you'd like to ask user something, then, I'm afraid, you shoud write your own client application, cause SQL Server does provide nothing to bild any interfaces.
|||

dear Sergey Gavrilenko,

is there any way that before running the integration service package i can ask the user to enter the file path of excel that he wants to use as the souce file.

if not easy way then please tell me the only possible way, even if i have to use visual studio .net to get the same.

thanks,