Hi roshanmaugustine. I am not trying to be rude here but I must say, I am sure that what you posted makes sense in your head, but reading it without knowing your environment created more questions for me than answers. Please give specific details as to your environment and situation. What kind of application? ASP.NET or is this a Windows Forms app located on the user's desktop? What do you envision the user executing directly?

- a stored procedure that executes an SSIS package

- an SSIS package that executes stored procedures

- both stored procedures and SSIS packages directly