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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 modify text file using a sp

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-10-03 : 10:02:52
chitts writes "Dear all:
I have three tasks and i am very new to sql server.
i)I want to read a text file and modify some of the contents.
ii)Then using bcp command to upload the text file into a table.
iii) Scheduld this stored proc or a batch program.

I knew how to do the second and third task task.
Can any one one help me to read the text file and modify its content.
Thanks in advance
-Chitts"
   

- Advertisement -