|
Subject:
|
Importing multiple text files to sql server db
|
|
Posted By:
|
tammyk
|
Post Date:
|
4/24/2008 8:00:56 AM
|
I need to import a large number of text files into a sql server database. I'm not very familiar with writing vbscript but I think that's what I need to do. Does anyone have some code where they do this that could be shared?
|
|
Reply By:
|
om_prakash
|
Reply Date:
|
4/25/2008 12:07:27 AM
|
You can use DTS OR BCP to copy the files which is a part of SQL server.
Please check the following url for BCP:
http://msdn2.microsoft.com/en-us/library/ms162802.aspx
Om Prakash
|
