SQLTeam.com | Weblogs | Forums

Users execute ssis 2008 package


#1

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?


#2

dtexec utility

dtexec utility


#3

You should go this one here you will find the steps involved in designing of a ne SSIS package.
http://www.codeproject.com/Articles/218914/Steps-to-Create-your-First-SSIS-Package