execute SSIS PKG Through Through Stored procedure

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

execute SSIS PKG Through Through Stored procedure

Author

Topic

kond.mohan
Posting Yak Master

213 Posts

Posted - 2011-12-23 : 01:35:12

Hi,

I want to execute SSIS (SQL SERVER 2008) PKG through stored procedure

i need to execute that pkgs dailay basis

can anybody explain how to write that stored procedure(how many ways we can write)

what conditions i have follw

tell me the sample example

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-23 : 01:50:10

you need to use DTExec utility for calling package from stored procedure.
You need to call it using xp_cmdshell inside

Then you can add a job in sql server agent to execute this procedure and schedule it as per your convinience

see
http://visakhm.blogspot.com/2011/10/different-ways-to-execute-ssis-package.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-23 : 01:50:46

and see here for full options on DTExec

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

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources