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 |
|
TSQLMan
Posting Yak Master
160 Posts |
 Posted - 2003-12-20 : 10:47:03
|
| I have a CSV File that needs to be imported to SQL daily. Can this be done using a stored procedure? Right now I use DTS,and it is a manual process, I would like to add a button a small vb app that executes a stored procedure, that does it sql server side. |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2003-12-20 : 11:05:40
|
| yup...look up BULK INSERT and BCP in the Books Online - fast, easy and configurable solutions. You could also schedule the stored procedure to run periodically if you want, using a Job (running under SQL Server agent).OwaisWe make a living out of what we get, but we make a life out of what we give. |
 |
|
|
TSQLMan
Posting Yak Master
160 Posts |
Posted - 2003-12-20 : 13:53:04
|
| Thanks,I looked at the help file. Looks like that will do it. |
|
|
|
|
|
|
SPROC To Import Text File