If you try to bulk insert varchar(max) or nvarchar(max) values, you get the following error:
While reading current row from host, a premature end-of-message was encountered--an incoming data stream was interrupted when the server expected to see more data. The host program may have terminated. Ensure that you are using a supported client application programming interface (API).
If you try to bulk insert varchar(max) or nvarchar(max) values, you get the following error:
PR incoming.