Get trailing spaces when import data from FoxPro

Hi,

We have a problem regarding the Visual FoxPro OLEDB driver. When we import data from FoxPro into SQLIS using Microsoft OLE DB Driver for Visual FoxPro, all string fields get spaces upto the it's field length.

Example:
Column A has a length of 10 characters. If we insert "bob" into that field in FoxPro and then read it from FoxPro and store it into SQL server. The resulting value in column A in SQL Server will be "bob ".

We are reading data from booth Visual Fox Pro and FoxPro using the same driver, we can't seem to find any OLE DB driver for FoxPro.

We have a solution which is to trim all the fields before storing them in SQL Server, but that we give us ALOT of work.

Is there anyone who has experienced the same problem and has an more elegant solution?Have you considered using the Derived Column transform in the data flow to trim your string columns?

Thanks.|||We have considered that solution, but that is our last option, as we have 50 tables and about 5-10 string columns in each... :(

So if there are anyone out there who has experienced the same problem with FoxPro and who has figured out some nice solution with the driver. We would highly appreciate to take advantage of your experiences..

Best regards,

Mattias