Download csv file from website ssis

For downloading the files from the server we can use FTP task but for the some cases we need to write the C code to download the files from the web server. We need to use the script task to achieve this. For the example I am using below web URL to download the csv file. Click OK. Now I am creating a flat file connection where we are going to store the downloaded file. AcquireConnection null ;.

AcquireConnection Dts. ToString ;. ServerURL, string. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Ask Question.

Asked 9 years, 7 months ago. Active 6 years ago. Viewed 36k times. Improve this question. Add a comment. Active Oldest Votes. My HTTP connection is pointing to the csv file. I have checked my username and password and I get through beyond the login page. Not sure what is wrong. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name.

Email Required, but never shown. The Overflow Blog. Podcast what if you could invest in your favorite developer? Who owns this outage? Building intelligent escalation chains for modern SRE. Featured on Meta. Now live: A fully responsive profile. Reducing the weight of our footer.