Thanks, Perry. That definitely got me going in the right direction. Still have some kinks to work out as i am doing the SSIS wizard import from another box, and it is having trouble finding the correct service on the host box, but that may be because I need to make sure that service is started first ( not the db engine, but the ssis service ) I've got something weird going on with the vfpoledb provider so have to do the import this way.

Any thoughts on how to TS a bad vfpoledb.dll? I tried unregistering, deleting, redownloading, reinstalling and reregistering ( all with SQL Engine shut down in case that matters ).

Tried searching registry for VFEOLEDB and deleting all keys I could find after the uninstall.

But in the import wizard, test connection succeeds but when I go to the step that would normally show the table to be imported I get a bad parameter error. Works fine on other box.



>You have to select the "connect" button and connect to "integration services".
>
>Under "integration services" find the folder you wish to save to. Rite-clicking the folder gets you the "Import Package" menu option.
>
>>Using the import wizard, I am saving SSIS packages to import VFP data into SQL tables. Works fine, but I haven't figured out how to
use the packages I'm saving. HELP says one of the options is to select IMPORT PACKAGE which is accessible from the Management Console. I'll be darned if I can find it.
>>
>>Help appreciated.