RE: Multiple SQL statements in one 'execute sql task'

#1

Try using:
PACK Firms
go
PACK Members
go

Hope it works

Miguel Salles

"Jean Paul" wrote:

Quote:

I am using DTS to export sql data to .dbf files

for the connection to the .dbf files I use Microsoft OLE DB provider for
Visual Foxpro

Before i export the data i want to empty the dbf files for that I create a
'execute sql task' with several statements.

ex.
PACK Firms;
PACK Members;
go;

When i launch this is is only the first sql statement that is executed.

What is wrong?

#2

I did that already. I also tried

Quote:

PACK FIRMS; PACK Members; GO
but it stays the same. Or I have an error for not accepting the sql

statement, or I have successful. But then it is only the first statement that
is executed.

It is not the pack that gives the problem I also have it wit other sql
statements (delete..,)

Jean Paul

"Miguel Salles" wrote:

Quote:

Try using:
PACK Firms
go
PACK Members
go

Hope it works

Miguel Salles

"Jean Paul" wrote:

I am using DTS to export sql data to .dbf files

for the connection to the .dbf files I use Microsoft OLE DB provider for
Visual Foxpro

Before i export the data i want to empty the dbf files for that I create a
'execute sql task' with several statements.

ex.
PACK Firms;
PACK Members;
go;

When i launch this is is only the first sql statement that is executed.

What is wrong?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

RE: Multiple SQL statements in one 'execute sql task'

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

RE: Multiple SQL statements in one 'execute sql task' - 09-21-2004 , 02:51 PM

RE: Multiple SQL statements in one 'execute sql task' - 09-22-2004 , 01:59 AM