Team Foundation Server with Git strips out connection Manager for SSIS Packages

  • Hi there

    We are using Git on Team Foundation Server for Visual Studio 2015 Community Edition.
    I am able to create a branch in TFS, make changes to a SSIS package in a Visual Studio solution project.
    The SSIS package has connection Managers at the project level.

    However, when i push changes for a package and issue a pull request, my colleague receives
    the package but the Project Connection Managers have been stripped out.

    Why does TFS using git,. strip out the Project Connection Managers from a modified SSIS package
    in team explorer?

  • chris.asaipillai-624309 - Wednesday, October 25, 2017 10:47 AM

    Hi there

    We are using Git on Team Foundation Server for Visual Studio 2015 Community Edition.
    I am able to create a branch in TFS, make changes to a SSIS package in a Visual Studio solution project.
    The SSIS package has connection Managers at the project level.

    However, when i push changes for a package and issue a pull request, my colleague receives
    the package but the Project Connection Managers have been stripped out.

    Why does TFS using git,. strip out the Project Connection Managers from a modified SSIS package
    in team explorer?

    Can you confirm that the relevant .conmgr files are under source control?

    If you aren't happy single, you won't be happy in a relationship.

    Remember, happiness comes from guitars, not relationships.

  • Phil Parkin - Wednesday, October 25, 2017 11:08 AM

    chris.asaipillai-624309 - Wednesday, October 25, 2017 10:47 AM

    Hi there

    We are using Git on Team Foundation Server for Visual Studio 2015 Community Edition.
    I am able to create a branch in TFS, make changes to a SSIS package in a Visual Studio solution project.
    The SSIS package has connection Managers at the project level.

    However, when i push changes for a package and issue a pull request, my colleague receives
    the package but the Project Connection Managers have been stripped out.

    Why does TFS using git,. strip out the Project Connection Managers from a modified SSIS package
    in team explorer?

    Can you confirm that the relevant .conmgr files are under source control?

    Hi there

    No the .conmgr files were not under git source control on TFS. If they are not and i have to add them in, they would automatically
    included with every package that uses them?

  • chris.asaipillai-624309 - Thursday, October 26, 2017 2:57 AM

    Phil Parkin - Wednesday, October 25, 2017 11:08 AM

    chris.asaipillai-624309 - Wednesday, October 25, 2017 10:47 AM

    Hi there

    We are using Git on Team Foundation Server for Visual Studio 2015 Community Edition.
    I am able to create a branch in TFS, make changes to a SSIS package in a Visual Studio solution project.
    The SSIS package has connection Managers at the project level.

    However, when i push changes for a package and issue a pull request, my colleague receives
    the package but the Project Connection Managers have been stripped out.

    Why does TFS using git,. strip out the Project Connection Managers from a modified SSIS package
    in team explorer?

    Can you confirm that the relevant .conmgr files are under source control?

    Hi there

    No the .conmgr files were not under git source control on TFS. If they are not and i have to add them in, they would automatically
    included with every package that uses them?

    Yes.
    Somewhere in TFS, I can't remember where, there are settings which control which files are, by default, excluded from source control. This includes executables, DLLs and other stuff which is usually not worth checking in. If you can find those settings, I suggest that you check them to ensure that .conmgr files are not also being excluded.

    If you aren't happy single, you won't be happy in a relationship.

    Remember, happiness comes from guitars, not relationships.

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

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