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

  • JimReeves71

    Ten Centuries

    Points: 1346

    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?

  • Phil Parkin

    SSC Guru

    Points: 243596

    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 the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

  • JimReeves71

    Ten Centuries

    Points: 1346

    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?

  • Phil Parkin

    SSC Guru

    Points: 243596

    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 the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

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

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