FTP Sites?

Question

FTP Sites?

Jeff Moden

SSC Guru

Points: 1004363
More actions
February 10, 2013 at 10:16 pm

#100871

Howdy folks,
I'm trying to setup a demonstration of how to download from FTP sites using T-SQL. The problem is, I don't know of any FTP sites that the general public has free access to. Do any of you know of such a site? Preferably, it would be a US site that's likely to be around for a good long time, probably some government site.
I could spend the time on Google looking for such a thing but I thought I ask you good folks first. Thank you for your help.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Viewing 12 posts - 1 through 11 (of 11 total)

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

Ant-Green SSC Guru Points: 113507 More actions · Answer 1

I dont know of any off the top of my head, but I do have a private FTP server on a dyndns lookup to my ISP in the UK if thats any use, wont take me a minute to make an account and set it up so you have access to a folder.

HowardW One Orange Chip Points: 29109 More actions · Answer 2

How about the National Climate Data Center:

ftp://ftp.ncdc.noaa.gov/pub/data/gsod

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 3

HowardW (2/11/2013)
How about the National Climate Data Center:
ftp://ftp.ncdc.noaa.gov/pub/data/gsod

By Jove! That might be just what the doctor ordered! The files are zipped using Gun-Zip, the directory structure is consistant and well laid out, and the file names have a definite structure (even if I do't yet know what the layout of that structure means). The site is free and looks like it will be available for at least the next couple of years so I can write some code and forget about having to do updates. This looks perfect. Thanks Howard!

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 4

anthony.green (2/11/2013)
I dont know of any off the top of my head, but I do have a private FTP server on a dyndns lookup to my ISP in the UK if thats any use, wont take me a minute to make an account and set it up so you have access to a folder.

That's VERY kind of you to offer, Anthony. I need this data to be around and stable for years, though (it's actually going to be in an article here on SSC). I also don't know how many hits this will take especially on the first day and it has to persist even if, God forbid, something were to happen to one or both of us. I also don't want it to be a burden on any private individual because it does have to persist for years.

I VERY much appreciate your find offer to help on this. There should be more people in the world like you.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 5

Jeff Moden (2/11/2013)
HowardW (2/11/2013)
How about the National Climate Data Center:
ftp://ftp.ncdc.noaa.gov/pub/data/gsod

By Jove! That might be just what the doctor ordered! The files are zipped using Gun-Zip, the directory structure is consistant and well laid out, and the file names have a definite structure (even if I do't yet know what the layout of that structure means). The site is free and looks like it will be available for at least the next couple of years so I can write some code and forget about having to do updates.

Thanks a million, Howard! This looks absolutely perfect.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Ant-Green SSC Guru Points: 113507 More actions · Answer 6

Jeff Moden (2/11/2013)
anthony.green (2/11/2013)
I dont know of any off the top of my head, but I do have a private FTP server on a dyndns lookup to my ISP in the UK if thats any use, wont take me a minute to make an account and set it up so you have access to a folder.
That VERY kind of you to offer, Anthony. I need this data to be around and stable for years, though (it's actually going to be in an article here on SSC). I also don't know how many hits this will take especially on the first day and it has to persist even if, God forbid, something were to happen to one or both of us. I also don't want it to be a burden on any private individual because it does have to persist for years.
I VERY much appreciate your find offer to help on this. There should be more people in the world like you.

Not a problem, not got round to editing the post after Howard's, his is a much better solution.

HowardW One Orange Chip Points: 29109 More actions · Answer 7

Jeff Moden (2/11/2013)
HowardW (2/11/2013)
How about the National Climate Data Center:
ftp://ftp.ncdc.noaa.gov/pub/data/gsod
By Jove! That might be just what the doctor ordered! The files are zipped using Gun-Zip, the directory structure is consistent and well laid out, and the file names have a definite structure (even if I do't yet know what the layout of that structure means). The site is free and looks like it will be available for at least the next couple of years so I can write some code and forget about having to do updates. This looks perfect. Thanks Howard!

No problem.

Narayana_17 SSC Eights! Points: 933 More actions · Answer 8

Hi,

Try these links ,

Hope they will help you to put/ get the files to/from FTP Sites

http://www.simple-talk.com/sql/t-sql-programming/pop-rivett-and-the-ftp-directory/

http://www.virtualobjectives.com.au/sqlserver/ftp_scripts.htm

http://haacked.com/archive/2006/04/21/sqlstoredproceduretoftpfilesfromsqlserver.aspx

http://beyondrelational.com/justlearned/posts/608/upload-all-files-from-source-folder-via-ftp-in-sql-server.aspx

Thanks

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 9

Thanks for the links, Narayana, but I already know how to do the things you have in the articles you provided links to, What I was looking for were sites that had publically available FTP sites that I could reliably do demos with.

Good links to have though. Thanks again.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Lowell SSC Guru Points: 323518 More actions · Answer 10

You probably have all the links you needed now Jeff, I'm late to the party on this one, but here's one more:

Project Gutenberg has a large number of ftp mirrors you could use as well: you'd have to pick a favorite from the list.

http://www.gutenberg.org/MIRRORS.ALL

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 11

Lowell (2/11/2013)
You probably have all the links you needed now Jeff, I'm late to the party on this one, but here's one more:
Project Gutenberg has a large number of ftp mirrors you could use as well: you'd have to pick a favorite from the list.
http://www.gutenberg.org/MIRRORS.ALL

You know me, Lowell. I hate to single source anything. Thank you VERY much for the alternate. I'll take a look.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)