Share via

How to check the TFS SSIS version with MSDB SSIS version ? | SSIS2014| TFS

Mudassar A 486 Reputation points
2020-08-18T13:57:26.513+00:00

How to check the TFS SSIS version with MSDB SSIS version ?

We have all ssis 2014 packages deployed on SSIS server . Now we need to check if they SSIS packages have the same version as TFS version.

Is there way to query them together to see the data to find mismatch ?

Can we do this using VS TFS ?

About Azure DevOps Server( TFS WEB )
Version Dev17.M153.3

VS 2013 PREMIUM

SSIS -2014

SQL server 2014

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,485 questions
0 comments
Accepted answer
  1. Yitzhak Khabinsky 25,301 Reputation points
    2020-08-19T13:36:01.123+00:00

    Hi DataArtist,

    SSIS packages *.dtsx are files in XML format.
    It is not easy to compare XML.

    The plan of actions would the following:

    1. Retrieve SSIS packages from MSDB database and put them on the file system.
    2. Retrieve SSIS packages from TFS and put the on the file system.
    3. Compare SSIS packages (XML files) via some utility like WinMerge and the like.

    WinMerge
    DiffMerge

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Monalv-MSFT 5,896 Reputation points
    2020-08-19T09:47:23.383+00:00

    Hi DataArtist,

    Could you please share the examples of TFS SSIS version and MSDB SSIS version?

    Hope the following links will be helpful:

    Install and configure Team Foundation Server

    How to find version of installed SSIS

    Best Regards,
    Mona

    ----------

    If the response is helpful, please click "Accept Answer" and upvote it.