SQL Server Integration Services SSIS 2005 - How to allow users to run the package?

Question

So, I made a package in SSIS to read data from a text file and load it into a database table.

What is the best way to configure this for non-technical end users to run this when necessary?

My boss thought that SP would launch it, and then publish the report made in Reporting Services, start the stored procedure. Of course there is a better way!

Answer 1

This is not entirely clear and contains many health warnings, but as an SSRS report, you can configure the use of the SSIS package as a data source - see http://msdn.microsoft.com/en-us/library/ms345250.aspx .

With this option, you can add an additional step to your SSIS package to output one (or more) report data sets to an SSRS report.

Answer 2

ASP.NET is a good solution: http://www.codeproject.com/KB/aspnet/SSIS_DOTNET.aspx

Answer 3

You can also create an SQL agent job to run a package with an empty schedule. Then create a web interface to call EXEC msdb.dbo.sp_start_job N'Your SSIS Job Name ';

Answer 4

At the command line:

DTEXEC.EXE / F "C: \ YOUR_PACKAGE.dtsx"

Full syntax here: http://msdn.microsoft.com/en-us/library/ms162810.aspx