Post reply

Named instance deployment for SSIS 2008 pkgs

  • October 1, 2009 at 9:00 am

    #136321

    Hello All -

    I have attached a word doc with screenshots and the contents of msdtssrvr.ini.xml file.

    Here's what I want to do:

    I have 1 SQL 2008 box - SQLDEV.

    It has 3 instances - the default (I dont use), SQLDEV, and SQLQA.

    The purpose was to save cash on our initial DW rollout by having dev and qa on same box.

    Not my idea, but I have to make it work, and fast.

    So, I want to deploy SSIS 2008 pkgs to SQLDEV\SQLDEV and later to SQLDEV\SQLQA.....separately.

    This way I can test my deployment process on QA and also the data will be different etc

    between DEV and QA.

    I am trying to "Act as though these are 2 separate boxes" so to speak.

    I have spent days on the net looking for help, and all I find is references to the

    ini file I mentioned above. Fine...I made the changes to the ini file but I still cannot

    deploy!

    What am I missing?

    Truly I am thrust into DBA role, whilst in reality I am ETL developer and DW Architect.

    Thanks!

    Tiffany

  • October 2, 2009 at 11:24 am

    #1061091

    Nevermind.

    I'm a fool.

  • October 2, 2009 at 8:18 pm

    #1061293

    We might go foolish too. Please share the solution.

    Thanks,

    Manu

  • October 5, 2009 at 6:16 am

    #1061657

    I ended up opening a MS incident via my MSDN subscription

    as I just could not get this straight.

    In the ini file I added 2 xml blocks for my 2 named

    instances...however I did not specify server name (just

    the instance name). So the entry needs to look like this:

    </Folder>

    <Folder xsi:type="SqlServerFolder">

    <Name>MSDB-SQLDEV</Name>

    <ServerName>SQLDEV\SQLDEV</ServerName>

    where SQLDEV is the box name and the names instance is also called

    SQLDEV.

    You'd think I would have figured this out, but nooooo.... 🙂

  • October 5, 2009 at 5:55 pm

    #1062050

    Thanks for sharing the solution.

    MJ

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

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