SSIS

  • Hi,

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

    Thanks

  • 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

  • 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

  • Thank you

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

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