I have a BO with a preconfigured data source of "VFPData".  I am trying to do a conversion from Fox data to SQL.  The FoxBO has to be able to look at many different files with the same structure.  So, is it possible to change the connectionstring of the VFPData datasource then call the fill method and have it look at a different table?  I would think this would work but it keeps looking at the original table.  I am even calling the dispose on the bo and creating it everytime I change the connectionstring. Any suggestions.

Sorry.  Answered my own question.  Stupid mistake on my part.  Thanks

I know you've already answered this for yourself, but the best way would be to just add a separate VfpDataSourceItem for each VFP connection string and just change the DataSourceKey on the business object to the appropriate data source when you need the data from a different one.