Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
overtmc
Starting Member
3 Posts |
 Posted - 2006-04-05 : 15:53:11
|
| I am a SQL novice. I need to create a job that will happen daily. I need to import a .csv file that is hosted on a website into a SQL server table. The .csv file always has the same 7 columns, and the file has a new timecoded filename every day. I want this to be fully automated, no downloading of files before import. A step by step procedure with code would me much appreciated. |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-04-06 : 04:47:24
|
| you will need your hosting company to help you on this one if that is the case... probably setup an ftp site on their side and then you can connect from your side, or ftp on your site then your apps that creates the csv files, access your ftp folder and dumps it therefrom there (can be a sql server or a machine that your sql server can access to pick up the files)for the import from csv to sql, check nr's mindsdoor.netHTH--------------------keeping it simple... |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
How To: Import .csv from URL to SQL daily