SSIS Download CSV from Web

Question

Post reply

SSIS Download CSV from Web

water490

Ten Centuries

Points: 1130
More actions
March 6, 2022 at 6:28 am

#3994133
hi everyone
My SSIS power query task is broken. Looks like the data provider changed the format for the source data so I need to redo this work. Rather than fixing the query I am going to start over. I need to create an SSIS package that downloads the CSV file found on this site. How can I do this? Once I download the file I can easily setup SSIS to import that data.
the link to the CSV file is
https://home.treasury.gov/resource-center/data-chart-center/interest-rates/daily-treasury-rates.csv/all/all?type=daily_treasury_yield_curve&field_tdr_date_value=all&page&_format=csv
If CSV is too much trouble then I am open to other ideas. The link to the site is
https://home.treasury.gov/resource-center/data-chart-center/interest-rates/pages/xml?data=daily_treasury_yield_curve&field_tdr_date_value=all
They also offer the data in XML so if that is easier to work with that is ok with me too.
Thank you
- This topic was modified 3 years, 6 months ago by water490.
- This topic was modified 3 years, 6 months ago by water490.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

frederico_fonseca SSCoach Points: 16251 More actions · Answer 1

did you try the script I posted on your previous post ?

https://www.sqlservercentral.com/forums/topic/get-data-from-internet-directly-into-sql-server#post-3969507

water490 Ten Centuries Points: 1130 More actions · Answer 2

frederico_fonseca wrote:

did you try the script I posted on your previous post ?
https://www.sqlservercentral.com/forums/topic/get-data-from-internet-directly-into-sql-server#post-3969507

This is going to show how much of a rookie I am. That code you helped with was for downloading file from SFTP server. However, this time I am accessing a CSV file from the website. How can I re-use that code to make it work for my particular case? They look different so I wasn't able to show how that could be modified for my new case. Sorry for the rookie question. I do not know much about coding.

frederico_fonseca SSCoach Points: 16251 More actions · Answer 3

the thread above is one you created before with the particular csv file for treasury - I gave you a functional powershell example to download it for their site and to load to a sql server table.

Has nothing to do with your other SFTP thread

water490 Ten Centuries Points: 1130 More actions · Answer 4

frederico_fonseca wrote:

the thread above is one you created before with the particular csv file for treasury - I gave you a functional powershell example to download it for their site and to load to a sql server table.
Has nothing to do with your other SFTP thread

OMG. I can't believe I missed that! This is so embarrassing! Clearly I cannot read! So sorry about that. I will take a look at that thread.