|
|
Posted by ntuyen01 on 08/09/06 21:34
I get it. Never mind.
ntuyen01@yahoo.com wrote:
> Hi All,
>
> I have a multiple files, but they are store in different directory on
> the server. I want open those files and insert it into the database
> using bcp.
>
> Example files structure dir:
> \\xyz\123\abc\text1.txt
> \\xyz\123\abc\text2.txt
> \\zyz\123\999\text2.txt
>
> bcp "dabase" in \\xyz\123\abc\text1.txt -c -S"servername' -Usa
> -Ppassword -T".
>
> is there away to loop througth each dir, get the files, excecute the
> bcp, then go to next folder.
>
> Please help. Thanks in advance.
>
> Ted Lee
Navigation:
[Reply to this message]
|