OpenXML oversize xml information

I am successfuly using OpenXML for some time now, but I encounter a problem when sometimes an xml string passed to sql is to large to fit the parameter.

How to sol开发者_运维百科ve this issue, instead of just limiting datatable length to fit the xml string.

Thanks

Why are you reading into a string? It's a zip file so ready it in binary mode direct into the OpenXML SDK. Or if you are not in .net, same thing but direct into whatever zip file library you are using.

Used xml instead of varchar to pass data to t-sql