Yeah, since it is your (otherwise brilliant) BCP code I was stealing I figured there was a good chance this issue had been pretty thoroughly researched <bg>
Still wrestling with the GUID(16) thing but didn't want to try to hack your BCP util to account for that if in the end I couldn't get the memo fields over that way anyway.
Unless an answer in the other thread shows me how to cast the guid(16)s as UID in one SSIS pull, I think I'm going to have to resign myself to an intermediary step of converting the GUID(16)s to GUID(36) in VFP before asking SQL to understand them. ( though I would swear that in DTS I was getting it to see the GUID(16) as a binary 16 and making a UID out of it )
>>Exploring options for migrating VFP data to SQL 2005.
>>
>>I don't know much about BCP but do I understand correctly that you can't move VFP memo fields to SQL Text or VARCHAR(x) this way?
>
>I have never had luck using BPC for memo fields, but I gave up rather quickly when I realized the extended computer time to import the memos using a view or SQLEXEC() was a lot cheaper than my time to figure out the BPC, assuming it was even possible.
>
>Since BPC is importing a text file, it didn't seem possible to find a delimiter that would work universally. On the other hand, decent documentation on BPC is very hard to find, so maybe there is some other way I never found.
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.
