Post reply

The SSIS service in 2012

  • May 27, 2012 at 12:14 am

    #261831

    Comments posted to this topic are about the item The SSIS service in 2012

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • May 27, 2012 at 12:20 am

    #1493572

    A good question. Helps to clarify SSIS concept.

    In fact when SSIS service stopped, one can execute the SSIS package using the following utilities,

    SQL server Import & Export Wizard

    SSIS Designer

    DTExecUI.exe

    DTExec.exe command prompt utility

    Reference: Description of the SQL Server Integration Services (SSIS) service and of alternatives to clustering the SSIS service - http://support.microsoft.com/kb/942176

  • May 27, 2012 at 1:04 am

    #1493577

    Good one.

    M&M

  • May 27, 2012 at 7:49 am

    #1493589

    Good question, help me re-affirm something I thought I knew and as it turned out I did know it.....

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • May 27, 2012 at 8:02 am

    #1493590

    Nice question

    Thanks

    IgorMi

    Igor Micev,My blog: www.igormicev.com

  • May 28, 2012 at 2:54 am

    #1493677

    Good question thanks.

    :exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:

  • May 28, 2012 at 3:47 am

    This was removed by the editor as SPAM

  • May 28, 2012 at 5:35 am

    #1493743

    good question!!!!

    thanks!

    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!

  • May 29, 2012 at 7:28 am

    #1494164

    Given that Integration Services is not cluster aware, you'd have to avoid its use on a cluster with multiple instances anyway. So it has to be done via the file system if you stack instances, at least in 2008. Haven't heard if 2012 changes that....

  • May 29, 2012 at 7:45 am

    #1494177

    Thanks for the question and info!

  • May 29, 2012 at 9:59 am

    #1494259

    Good question.

    But my brain is not working right today. I thought to myself "can I execute a package if SSIS service isn't running? Yes, of course I can" and ticked "YES", which of course is the opposite (because the question doesn'tsya can you do that, it says do you need SSIS service running to execute a package). Shouldn't try to answer QotD when brain not sufficiently in gear.

    Tom

  • May 29, 2012 at 10:06 am

    #1494265

    thanks for the question - cheers

  • May 29, 2012 at 10:12 am

    #1494269

    A simple one for me - I am dealing with SSIS daily. Thanks, Koen!

  • May 29, 2012 at 10:39 am

    #1494285

    thanks Koen

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • May 29, 2012 at 1:57 pm

    #1494362

    jeff.mason (5/29/2012)

    Given that Integration Services is not cluster aware, you'd have to avoid its use on a cluster with multiple instances anyway. So it has to be done via the file system if you stack instances, at least in 2008. Haven't heard if 2012 changes that....

    Not really sure about 2012. In the project deployment model, SSIS resides inside the database engine, so I would tend to believe it behaves a bit better in a clustered environment.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 15 posts - 1 through 15 (of 16 total)

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