I am very glad to hear this. Perhaps I am misunderstanding the messages I am getting. I will now do some controlled experiments importing VFP data into SQL Server 2005 using SSIS and the VFP OLEDB provider and come back with questions. you certainly saved me on the use of DTS with C(36) guid fields -> uniqueidentifier.
BTW, I discovered that guid(16) fields in VFP will convert directly to uniqueidentifiers, since they are read as binary(16)
(this was particularly useful since VFE's original implementation of GUID() was a c(16) nocptrans.
Yeni yiliniz kultlu olsun !
>>Oh, and if you are working in SQL 2005 and can figure out how to get the VFP OLEDB provider to work with SSIS ( the new DTS ) please let me know.
>
>Hey Charles,
>If you tell where it fails for you I can help. Actually I found it to be better than DTS (and all other things - I can't resist to say SQL2005 rocks! It's cool.)
>Cetin
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.