Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
I'm new to SSIS. I can see "FTP Task" in the SSIS toolbox in VS2015 Community edition. Is there an HTTP equivalent?
I have a HTTP url and some user credentials. Shared via the HTTP url is a .sql file. I want to login and download the file every Sunday @ 1am.
Can anyone point me in the right direction please?
Your only option is going to be calling a script. Either using PowerShell script via Execute Process task, or using C# in a Script Task to download it.
For the PowerShell script you would use Invoke-WebRequest as it supports passing in credentials. A good example of this can be found here. The example from the article:
$Credentials = Get-Credential
Invoke-WebRequest -Uri "https://www.contoso.com" -OutFile "C:\path\file" -Credential $Credentials
To keep from being prompted you can use various ways to encrypt it, just depends on if the password has to be kept secure. If not just modify it to be something like this:
$pwd = ConvertTo-SecureString "MyT0pSecr3tP@ssw0rd" -AsPlainText -Force
$creds = New-Object System.Management.Automation.PSCredential (“username”, $pwd)
Invoke-WebRequest -Uri "https://www.contoso.com" -OutFile "C:\path\file" -Credential $creds