I've had this problem when migrating a FPW2.6 database to Oracle.

I split the upload into smaller number of records in each package, maybe 10,000 records per batch. And then it worked.

Paul


>If someone could point me in the right direction with this error message I would be very grateful.
>
>I am inserting records from a text file through a remote view into a SQL Server table. The SQL Table has an insert trigger which updates other files from the inserted record's values.
>
>I get through a little more than 30,000 records (out of more than 150,000 total) before I get this error message:
>
>"Connectivity Error:[Microsoft][ODBC SQL Server Driver][SQL Server]There is insufficient memory to run this query."
>
>I have 256 megs on the Server (which is dedicated to run SQL) and mine is the only database on the server.
>
>
>Anyone have any ideas on how I can work around this?
>
>Any suggestions would be greatly appreciated.
>
>
>Thanks.