Post reply

SSIS

  • February 7, 2014 at 2:29 pm

    #288001

    Hi,

    Please some one let me know how to run the ssis package on the fly .

    Thanks

  • February 7, 2014 at 2:31 pm

    #1687249

    Connect to the SSIS server, rt-click, execute package?

    Otherwise, more details, please.

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

  • February 7, 2014 at 3:33 pm

    #1687263

    Deploy the package to SSIS.

    Configure a job to execute it.

    From ssms you can call:

    USE msdb ;

    GO

    EXEC dbo.sp_start_job N'Job_calling_ssis_package' ;

    GO

    You can put that code in a SP and execute it.

    From .NET you can call the SP executing the job.

    Regards,

    Igor Micev

    Igor Micev,My blog: www.igormicev.com

  • February 8, 2014 at 5:51 am

    #1687310

    Thank you

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

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