April 24, 2017 at 11:56 am
Hello,
I am looking to query TFS data using SSIS . Please suggest how I can retrieve data from TFS.
Thanks,
PSB
April 24, 2017 at 12:40 pm
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
April 24, 2017 at 12:57 pm
Haven't yet . Was looking for retrieving through SSIS .
April 24, 2017 at 1:30 pm
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
April 24, 2017 at 2:41 pm
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?
April 24, 2017 at 3:21 pm
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