Linked Server

Hi,

Is there a way to batch INSERTs from a linked server?

For example, I'm importing data into a sql db using the following linked server query.

SELECT * INTO SQLDB.dbo.Table_SS FROM OPENQUERY (ORACLELINK, 'SELECT * FROM SCHEMA.Table_Ora')

If the table Table_Ora has say 5 million rows..........is there anyway that we can batch the INSERTs so that the query will commit at say every 30 or 40k rows?

or any other better approaches?

Thanks,
Siva.

[503 byte] By [Siva116] at [2008-1-2]