 | |
Execute SSIS package from a sql stored procedure
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Execute SSIS package from a sql stored procedure -
04-21-2008
, 10:38 AM
#2
| |||
| |||
|
|
How can I execute a SSIS package from a stored procedure? Thank you. |
The answer is: Kinda
AFAIK, it is not possible to run the package directly, however you can
run DTEXEC using xp_cmdshell (good luck getting your DBA to grant
permissions for that!) or you can create a SQL Agent job and start it
using sp_start_job.
Good luck!
J
#3
| |||
| |||
|
|
How can I execute a SSIS package from a stored procedure? Thank you. |
The answer is: Kinda
AFAIK, it is not possible to run the package directly, however you can
run DTEXEC using xp_cmdshell (good luck getting your DBA to grant
permissions for that!) or you can create a SQL Agent job and start it
using sp_start_job.
Good luck!
J
#4
| |||
| |||
|
|
How can I execute a SSIS package from a stored procedure? Thank you. |
The answer is: Kinda
AFAIK, it is not possible to run the package directly, however you can
run DTEXEC using xp_cmdshell (good luck getting your DBA to grant
permissions for that!) or you can create a SQL Agent job and start it
using sp_start_job.
Good luck!
J
#5
| |||
| |||
|
|
How can I execute a SSIS package from a stored procedure? Thank you. |
The answer is: Kinda
AFAIK, it is not possible to run the package directly, however you can
run DTEXEC using xp_cmdshell (good luck getting your DBA to grant
permissions for that!) or you can create a SQL Agent job and start it
using sp_start_job.
Good luck!
J
#6
| |||
| |||
|
|
How can I execute a SSIS package from a stored procedure? Thank you. |
The answer is: Kinda
AFAIK, it is not possible to run the package directly, however you can
run DTEXEC using xp_cmdshell (good luck getting your DBA to grant
permissions for that!) or you can create a SQL Agent job and start it
using sp_start_job.
Good luck!
J
#7
| |||
| |||
|
|
How can I execute a SSIS package from a stored procedure? Thank you. |
The answer is: Kinda
AFAIK, it is not possible to run the package directly, however you can
run DTEXEC using xp_cmdshell (good luck getting your DBA to grant
permissions for that!) or you can create a SQL Agent job and start it
using sp_start_job.
Good luck!
J
#8
| |||
| |||
|
|
How can I execute a SSIS package from a stored procedure? Thank you. |
The answer is: Kinda
AFAIK, it is not possible to run the package directly, however you can
run DTEXEC using xp_cmdshell (good luck getting your DBA to grant
permissions for that!) or you can create a SQL Agent job and start it
using sp_start_job.
Good luck!
J
#9
| |||
| |||
|
|
How can I execute a SSIS package from a stored procedure? Thank you. |
The answer is: Kinda
AFAIK, it is not possible to run the package directly, however you can
run DTEXEC using xp_cmdshell (good luck getting your DBA to grant
permissions for that!) or you can create a SQL Agent job and start it
using sp_start_job.
Good luck!
J
#10
| |||
| |||
|
|
On Apr 21, 4:38 pm, Jack <J... (AT) discussions (DOT) microsoft.com> wrote: How can I execute a SSIS package from a stored procedure? Thank you. Hi Jack, The answer is: Kinda AFAIK, it is not possible to run the package directly, however you can run DTEXEC using xp_cmdshell (good luck getting your DBA to grant permissions for that!) or you can create a SQL Agent job and start it using sp_start_job. Good luck! J |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.