Loop in a Windows Batch File

Question

I'm trying to create the following batch file:

@echo off

set "list=AICourse AIStudent Teacher"
set Server="localhost"
set Username="user"
set Password="()$rDCg3st@0"

    for %%n in (%list%) do (

        Set File=c:\temp\%%n.bcp
        Set Log=c:\temp\%%n.log_exp

        ECHO Begin BCP...: %TIME% 
        ECHO waiting...

        bcp Database.dbo.%%n OUT %File% -o %Log% -S%Server% -U%Username% -P%Password% -c

        ECHO End BCP..: %TIME% 
        ECHO Log in file %Log%

    )

However, when I try to iterate through the array, only returns the last result. How can I iterate then?

aphoria · Accepted Answer · 2014-01-23 20:43:12Z

2

Add this at the top of your script:

SETLOCAL ENABLEDELAYEDEXPANSION

And, then change all the %Log% instances to !Log! and %File% instances to !File!.

edited Jan 23, 2014 at 20:43

answered Jan 23, 2014 at 18:51

aphoria

20.3k8 gold badges67 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

D. Scott Over a year ago

Adding that the tag %File% needs to be modified to!File! too. thanks.

aphoria Over a year ago

Oops, I missed that one...added it to the answer.

Collectives™ on Stack Overflow

Loop in a Windows Batch File

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related