Restriction for text, image, and unitext with bulk copy

When you use bulk copy to copy text, unitext, and image values to a remote server, the server must store the values in data pages before sending them to the remote server. Once the values have been issued to the remote server, the data pages are released. Data pages are allocated and released row by row. This is important because:

• The overhead of allocating and releasing data pages impacts performance.

• Data pages are allocated in the database where the table resides, so the database must be large enough to accommodate enough data pages for the largest text, unitext, and image values that exist for any given row.