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.
| Author |
Topic |
|
rcr69er
Constraint Violating Yak Guru
327 Posts |
 Posted - 2008-04-30 : 06:58:15
|
| HiI have a SSIS package stored on the database server under Stored Packages within the Integration Services section. Does anyone know how to run this package using SQL?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-30 : 07:36:51
|
| You can configure a job for running the SSIS package in SQL Server Agent and then use SQL system stored procedure sp_start_job to start the job which executes the package. |
 |
|
|
rcr69er
Constraint Violating Yak Guru
327 Posts |
Posted - 2008-04-30 : 07:39:55
|
| HiThanks for that!Is there anyway of running the package without using SQL Server Agent, for example using EXEC xp_cmdshell? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-30 : 07:43:27
|
| Yup. You can use:-xp_cmdshell 'dtexec ..."' |
|
|
|
rcr69er
Constraint Violating Yak Guru
327 Posts |
Posted - 2008-04-30 : 07:53:38
|
| HiThanksCan you show me the full syntax as I am new to using dtexec.Also I have now saved the package within the MSDB folder under Integration Services.Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-30 : 07:55:10
|
| http://msdn.microsoft.com/en-us/library/ms162810.aspx |
|
|
|
|
|
|
Running a Stored Package