Posted by ntuyen01 on 08/09/06 15:23

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

• Next in forum: Re: SQL Server Management Studio can't 'see' the 2005 engine?? But can see 2000 ?!?
• Prev in forum: Skip rows where the first column with letter 'S' - BCP
• Thread view: Get files in different folder using sql

[Reply to this message]