Hi Mike,

>We only get this error when we pass a text file which is (171 MB) to a parameter of data type (TEXT)

That is quite a bit for a SQL server parameter... Have you tried different connection methods? The error might only occur with TCP/IP but not with named pipes, or vice versa.

If nothing works, you might have to split the file into two and combine them on the server side.