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 |
|
thanksfor help
Posting Yak Master
106 Posts |
 Posted - 2007-09-20 : 13:36:53
|
| Hi,I have to download a csv file from a web page,unzip the file and upload it to sql server table.This task has to be repeated daily. Any suggestions is very much appreciated.thanks in advance. |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-20 : 13:39:47
|
quote:
Originally posted by thanksfor help
Hi,I have to download a csv file from a web page,unzip the file and upload it to sql server table.This task has to be repeated daily. Any suggestions is very much appreciated.thanks in advance.
Which part are you looking to automate? You can use a windows script to pull the file, unzip and then use BCP or DTSRUN from a command line in the script to import into SQL. You can then call the script in a scheduled task to run daily.
Future guru in the making. |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-09-20 : 14:18:06
|
you can also use a .net stored procedure if you really have to do this from sql server. just saw that you're using sql server 2000else i'd go with Zoroaster's suggestion._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
|
|
|
download csv file from web and upload to sql table