Execute SSIS package from a sql stored procedure

#21

I would not recommend xp_cmdexec. You might create deadlock, your process is
also waiting, and your server become open for attack.

Try to crete the job and use sp_start_job to start the job.

Tomasz B.

"Jack" wrote:

Quote:

How can I execute a SSIS package from a stored procedure?
Thank you.

#22

I would not recommend xp_cmdexec. You might create deadlock, your process is
also waiting, and your server become open for attack.

Try to crete the job and use sp_start_job to start the job.

Tomasz B.

"Jack" wrote:

Quote:

How can I execute a SSIS package from a stored procedure?
Thank you.

#23

I would not recommend xp_cmdexec. You might create deadlock, your process is
also waiting, and your server become open for attack.

Try to crete the job and use sp_start_job to start the job.

Tomasz B.

"Jack" wrote:

Quote:

How can I execute a SSIS package from a stored procedure?
Thank you.

#24

I would not recommend xp_cmdexec. You might create deadlock, your process is
also waiting, and your server become open for attack.

Try to crete the job and use sp_start_job to start the job.

Tomasz B.

"Jack" wrote:

Quote:

How can I execute a SSIS package from a stored procedure?
Thank you.

#25

I would not recommend xp_cmdexec. You might create deadlock, your process is
also waiting, and your server become open for attack.

Try to crete the job and use sp_start_job to start the job.

Tomasz B.

"Jack" wrote:

Quote:

How can I execute a SSIS package from a stored procedure?
Thank you.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Execute SSIS package from a sql stored procedure

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

RE: Execute SSIS package from a sql stored procedure - 05-02-2008 , 09:18 AM

RE: Execute SSIS package from a sql stored procedure - 05-02-2008 , 09:18 AM

RE: Execute SSIS package from a sql stored procedure - 05-02-2008 , 09:18 AM

RE: Execute SSIS package from a sql stored procedure - 05-02-2008 , 09:18 AM

RE: Execute SSIS package from a sql stored procedure - 05-02-2008 , 09:18 AM