Good book – look at Professional SSIS from Wrox or the new release from MS Press for which the name escapes me at the moment.
As for Importing DBase files – you’ll need to configure your connection manually to connect. Set up a Jet OLEDB Connection – point to your folder containing the DBase files. Click the “All” button and change the “Extended Properties” to “DBASE IV”. For Paradox files, you’ll use “Paradox 5”. For Foxpro files, you’ll need to use the OLEDB Provider for Foxpro and point it to your folder/file. I didn’t have any major issues with this that I remember.
Create a connection to your DBase files.
Create a connection to your FoxPro files
Create a Data Flow task
Add an OLEDB Source – assign this to your DBase connection.
Add an OLEDB Destination
Add any transforms needed between the Source and Destination or just drag the arrow between them if no transforms are needed.
Once you’ve done this, double-click the destination to set the properties.
Assign the FoxPro OLEDB connection to the destination, check the mappings.
That should handle everything – click the “Run” button and you should be started. You may need to tweak things to convert successfully, but this would be the basic method.