How to query tfs within your ssis package

  • Hello,

     I am looking to query TFS data using SSIS . Please suggest how I can retrieve data from TFS.

    Thanks,
    PSB

  • I suggest that you work out how to do it outside of SSIS first. Have you already got that bit worked out?

    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

  • Haven't yet . Was looking for retrieving through SSIS .

  • As far as I know, TFS stores all data in SQL Server databases.
    If you can't work out how to query this data in T-SQL, I can't see how SSIS will help you one bit.

    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

  • Yes, TFS does store things in SQL Server databases, with names such as:
    Tfs_DefaultCollection
    Tfs_Warehouse
    (plus a bunch to support SSRS and SharePoint)

    Do you know what information you're trying to get out of TFS?

  • Unfortunately we will not have access to the TFS Sql server database . We are thinking of using rest API using SSIS if possible.

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

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