MS SQL Server - Using CL command in SQL 2000

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Using CL command in SQL 2000

Sphenix

2006-10-24, 6:32 pm

Is it possible to CL command in "Execute SQL Task" by using ODBC
connection
Btw I'm using "SQL 2000/8.0"
(e.g. CL: CPYF FROMFILE(LibraryA/TableA) TOFILE(LibraryB/TableB)
CRTFILE(*YES))

John Bell

2006-10-24, 6:33 pm

Hi

This command does not exist in SQL Server, depending on what you want to do
there is the option for using SELECT...INTO or INSERT...SELECT. If you want
to load from a file on the OS try BULK INSERT or BCP. Another option would be
to use the import/export wizard and create a DTS Package or write your own
DTS package and include the Copy Object task.

John

"Sphenix" wrote:

> Is it possible to CL command in "Execute SQL Task" by using ODBC
> connection
> Btw I'm using "SQL 2000/8.0"
> (e.g. CL: CPYF FROMFILE(LibraryA/TableA) TOFILE(LibraryB/TableB)
> CRTFILE(*YES))
>
>

Sponsored Links