Sql Task with Oracle -- sql server dts

Akshay Mittal
12/25/2004 12:27:02 AM

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.

[quoted text, click to view]

Jéjé
12/26/2004 4:29:10 PM

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@discussions.microsoft.com> a écrit dans
le message de news: CC410FB5-5615-4452-92C1-5975B6AB3187@microsoft.com...
[quoted text, click to view]

Denis Desjardins
12/30/2004 6:51:01 AM

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.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

sql server dts : Sql Task with Oracle