I am new to creating SSIS 2008 packages. What I want to do is to create a simple SSIS package and have the users 'run' the package when the needs arise. This cannot be a scheduled job since a user needs to determine when there is enough data to process.
Is there some tool SSIS tool? Is there some kind on excutable, dll, and/or app the user can click on to run the package?
Thus can you tell me and/or point me to ways that I can setup a process for a user to execute the ssis package?