Mar 25 2024 08:54 PM
Greetings.
I'm working with a solution called Encompass that runs on AWS.
I've been provided URLs that look like this:
The link has been modified for privacy.
If you enter the actual URL, you are prompted to download a file.
I'd like to be able to connect to this and other URLs to automate downloading the files.
Is that possible in SSIS?
Thank you
Mar 25 2024 10:51 PM
Is that possible in SSIS?
Should be, but highly depends on what that web API returns. SOAP, XML, Json, or ...; you haven't mentioned that.
See for example Web Service Task - SQL Server Integration Services (SSIS) | Microsoft Learn
Other option is a .NET script task Script Task - SQL Server Integration Services (SSIS) | Microsoft Learn