Post reply

Calling SSIS package from Stored Procedure

  • September 24, 2010 at 1:17 am

    #238767

    Hello there,

    I want to call a SSIS package which is stored in file system (\\srtb03.dr.infosir.com\tb\Package1.dts) through T-SQL script (stored procedure).

    Can anyone help me in this ?

    Regards,

    PT

  • September 24, 2010 at 7:40 am

    #1226966

    Use the dtexecui to build the execute package command.

    Copy the command to your Stored Procecure, executing it with xp_CmdShell (or a CLR Procedure).

  • September 24, 2010 at 7:53 am

    #1226982

    Actually, now I think about it you could probably schedule it with Sql Agent and start it with sp_start_job.

    All this being said, I can't say any issues you may run into as I haven't actually tried either approach myself.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply