Connecting to URL to Download Within SSIS

Copper Contributor

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

1 Reply

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