Yes foreign keys can be a pain for imports and exports. Make sure you import/export the related tables first. That should clear that up. Alternately if you remove the keys...

Did you try to run it rather than just preview it? Just curious if would run. Probably not.

That's strange. I just ran a test exactly as you describe and I can preview the data fine. I'll think on this and if I come up with anything, I'll...

I assume your using the DTS wizard in enterprize manager? If so make sure you are using the correct data type within the wizard. If your importing from Access, it...