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 |
|
flanz_g
Starting Member
22 Posts |
 Posted - 2007-01-04 : 12:34:45
|
Hi All, "Happy New Year!"I need to append data to the existing Table1 from a .txt file stored like this: "http://xx0opt02.corpuk.net/ABC_REPORTS/DATA/Table1.csv"(Columns are identical)This .csv contains a rolling 7 days of stats. which means if it is added every Morning 6 of those Days will have been added before and must be Deleted. I would like to schedule an automatic procedure to create a temp table in the server every day and a script removing duplicates.I have a few questions:*) Can I shedule from the Enterprise Console to read/create table from the above link to do this?**) I heard I need an SQL agent. If so why and what is it?***) Is it better to append data and then script removing Duplicates, or is it better to import into a temp table run comparison between the 2, Delete from Temp what is Common and then append whats left of the Temp to the Table1?****) Please could someone paste a sample of CREATE TABLE from a http link like the one above?Thanks for your help,Gezza |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-01-06 : 02:23:29
|
| That link does workMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Creating a Temp table from a URL