>>COPY TO 'PipeDelimitedFile.txt' DELIMITED WITH "" WITH CHARACTER '|'
>
>
>Turned out to be a very good way to go. Table has 2.5 million records. 6 columns had to be transformed from GUID(16) to GUID(32) . First did a SELECT to do the transform then the COPY to to create the text file. That took about 10 seconds all together. Bulk upload on the SQL side took about another 10 seconds.

Hi,
How do you handle Memo fields ?
Copy to ignores them.