I'm fairly new to DTS. I'm running a Dts where the source and the destination
are Oracle databases. I need to run some Sql statements to create temporary
tables and proper indexes before doing any more complex stuff. When trying to
run those statements in an Sql Task, it seems that i'm only able to run one
statement per Sql task. Is it the normal behaviour, or am i missing something
here?

Thanks

The task can contain either a single SQL statement or multiple SQL statements
that execute sequentially. SQL statements can range from being a SELECT
command to running a stored procedure.

The SQL statements must be written in the dialect of the source database
management system (DBMS).

If multiple statements are contained in the task, they can be grouped and
executed a batch at a time. To signal the end of a batch, use the GO command.
All the SQL statements from one GO command to the next are sent in a batch to
the OLE DB provider for execution.

For more information look for topic "Execute SQL Task" in Books Online.


"Denis Desjardins" wrote:

try some keywords like:
Statement A ;
Statement B ;
Statement C ;

or
Statement A
Go
Statement B
Go
Statement C
Go

or
/
Statement A
/
Statement B
/
Statement C


"Denis Desjardins" <Denis Desjardins (AT) discussions (DOT) microsoft.com> a écrit dans
le message de news: CC410FB5-5615-4452-92C1-5975B6AB3187...soft (DOT) com...

Thanks for the info guys.
The proper way of doing it is by following each sql statements by the GO
keyword.

Thanks a lot it was really helpful.



"Jéjé" wrote: