Execute SSIS package via sp

Is there a way to run an SSIS package via a stored procedure? I haven't foun
d
anything in BOL. I am currently doing this by running a job that executes th
e
package, but was wondering if there's a new sp for this.
Thanks, and happy new year,
TomTHi Tom,
Happy New Year!
From your descriptions, I understood you would like to know whether it is
possible to execute the SSIS via stored procedure. If I have misunderstood
your concern, please feel free to point it out.
Based on my knowledge, SQL Server 2005 introduced a new command prompt
utility dtexec. Using dtexec, you can run packages that are stored either
in the file system, in an instance of SQL Server 2005, or in the
Integration Services Package Store.
For more information, please refer the links below
How to: Run a Package Using the DTExec Utility
http://msdn2.microsoft.com/en-us/library/ms138023.aspx
Command Prompt Utilities (SSIS)
http://msdn2.microsoft.com/en-us/library/ms140258.aspx
Running Packages
http://msdn2.microsoft.com/en-us/library/ms141708.aspx
Alternatively, SQL Agent has a new feature called subsystems that makes it
possible to directly execute packages.
SQL Server Agent Subsystems
http://msdn2.microsoft.com/en-us/library/ms187100(en-US,SQL.90).aspx
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Thanks Michael, I think I'll stick with creating a job, and running that fro
m
an sp.
"Michael Cheng [MSFT]" wrote:

> Hi Tom,
> Happy New Year!
> From your descriptions, I understood you would like to know whether it is
> possible to execute the SSIS via stored procedure. If I have misunderstood
> your concern, please feel free to point it out.
> Based on my knowledge, SQL Server 2005 introduced a new command prompt
> utility dtexec. Using dtexec, you can run packages that are stored either
> in the file system, in an instance of SQL Server 2005, or in the
> Integration Services Package Store.
> For more information, please refer the links below
> How to: Run a Package Using the DTExec Utility
> http://msdn2.microsoft.com/en-us/library/ms138023.aspx
> Command Prompt Utilities (SSIS)
> http://msdn2.microsoft.com/en-us/library/ms140258.aspx
> Running Packages
> http://msdn2.microsoft.com/en-us/library/ms141708.aspx
> Alternatively, SQL Agent has a new feature called subsystems that makes it
> possible to directly execute packages.
> SQL Server Agent Subsystems
> http://msdn2.microsoft.com/en-us/library/ms187100(en-US,SQL.90).aspx
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
=============
> This posting is provided "AS IS" with no warranties, and confers no rights
.
>|||Hi Tom,
You are welcome, as always:)
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.