How can I export multiple tables from SQL SERVER 2005 to corresponding multiple files in the most efficient way?

Try using the Import/Export wizard from SQL Server Management Studio. Then when you have made all your choices of source, destination, etc, SAVE the resulting package instead of running it. Open it in Visual Studio (BIDS) and take a look at what it created for you.Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.

You can also try to create script that uses bcp to export data to flat files. Usually bcp has good performance. bcp AdventureWorks.Production.Product out "C:\tmp\Product.txt" -T With kind regards Krystian Zieja http://www.projectnenvision.com Follow me on twitter My Blog

Hi, You have 3 options basically : using ssis, import export wizard or bcp utility Now the fact remains that when it is an import operation to SQL server,they perform nearly the same. But in case of exporting to text files frm SQL Server, bcp wins. Thanks.Regards, Sonal

I use a small script utility in SQL Server to generate a full list of BCP commands for a specific database. If you open up management studio and run the following in a query window for the database you want to export, it'll generate one BCP command for every table which can be run on the command line or saved into a batch file and scheduled: select 'bcp ' + st.name + ' out c:\' + st.name + '.csv -T -c -d ' + DB_NAME() from sys.tables st file locations can be easily changed by altering the script