Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  How to export all my tables to flat file

Author  Topic  Nith Starting Member 17 Posts Posted - 2010-05-31 : 22:55:57 Dear Buddies, Seasonal greetings to all. I am using SQL Server 2005 and I need to transfer around 7 databases to text format. Each has around 260 over tables. Its not going to be a regular things, just a one time job. I am right clicking and performing the desired action but is there a way to automate it? Please kindly guide me. Thanking all of you in advance. Regards, Nith