Post reply

config file is hard coded with UNC path rather than the relative path

  • February 27, 2013 at 4:20 pm

    #144218

    Guys,

    We are using Mercurial Hg for Source code control for our SSIS packages.

    Hg works by pulling the entire repository to your local machine, making SCC changes to the local copy and then pushing all the booked in changes back to the central repository. This means that two developers can have the entire repo on their machines

    Bobs machine

    C:\windows\users\bob\desktop\HG Repo\SSIS packages\....

    Daves machine

    C:\windows\users\dave\desktop\HG Repo\SSIS packages\....

    When you define dtsConfig files in the project or solution folder the path to the file is the full UNC. This means that if Bob books in a package and then Dave books it out the dtsConfig file path is specified as being under Bob's user directory when in fact it is now under Dave's. is there any way to get the dtsConfig reference to be relative to the dtsx file rather than the full path. It is not the end of the world, but it is a bit of a PITA when developers are sharing packages (e.g. peer review)

  • February 27, 2013 at 5:25 pm

    #1591799

    The path is hard coded into the registry. If you need to retrieve it from a different location, it will require changing the registry for each person that will check it out or check it in.

    http://msdn.microsoft.com/en-us/library/ms137789.aspx

    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

  • February 28, 2013 at 7:35 am

    #1591979

    Have you considered alternative config models?

    Using an indirect XML config file to point at the location of your 'SSISConfig' database (named however you like) and having everything else reading from whichever SSISConfig database is being 'pointed at' works well, in my experience. You'd avoid issues like this.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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