In some cases, it can be useful to retrieve data from a web service. For instance, you could retrieve current or historic exchange rates for converting currencies in your project. While you cannot simply point TX to a web service and fetch data, it is fairly straightforward to get web data into your project.
Step by step
- Create a SSIS package that reveives data from a webservice and stores the data in a SQL Server table.
- Use the SQL Server Table populated by the SSIS package as a data source in your TX project.
- Optional: Set the SSIS package up to be executed from the TX Execution package.
This article applies to: timeXtender 4.5, tX2012, TX2014. Last updated: 2014-03-28.