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 |
|
bharadwaj54
Starting Member
2 Posts |
 Posted - 2009-09-17 : 06:36:43
|
| Hi Guys,My database is hosted by a thrid party.My database is Microsoft Sql server 2000.Every day at a specific time of the day CSV files present in one of the folders on my company server have to be uploaded on to one of the tables of the database.I am using the GUI tool MS SQL Server management studio to connect to the database.The uploading of the file and inserting the values of the files in the database table should be all automatic.For example every day at 10pm a file called Products.csv is present on my office server at C:\Products\Products.csv The file has say 1000 rows.All these 1000 rows have to be automatically inserted into the database table tbl_Products.After inserting all the rows in the file the file should de stored some where as back up on the db.How to do this automatically??Please help.Best Regards,BP. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-09-17 : 07:32:11
|
In SQL Server 2000 you can develop a DTS-package to do what you want and then you can schedule this package in SQL Server agent job to run each day at same time.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
bharadwaj54
Starting Member
2 Posts |
Posted - 2009-09-18 : 21:09:23
|
| Thanks for your valuable help.I am bit new to the sql server environment.Can you please suggest a good article which suits my requirement.Also do I have to ask my web site hoster to set any settings for my sql server to do this task.If so whatdo i need to ask?Cheers,BP. |
|
|
|
|
|
|
Upload CSV file to the database and load it to db