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?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
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