I'm afraid I'm not an expect in SSIS. You probably can set up a package to iterate over tables in a database but I don't know how to do that. If there are not many tables in your database and the design is not likely to change, you could manually set up tasks to export each table. I suggest you read the SSIS documentation to find out what it is capable of doing. Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

There is an open source tool here that might do what you're after. Google is your friend. Use him, that's what friends are for.;P "You're very clever, young man, very clever," said the old lady. "But it's turtles all the way down!"