Hi Everyone, i need a script to export data from all tables of database to a textfile and for each table a new text file should be created . Could you please assist? Please let me know if i am not clear with my question . ------------------------ Thanks,Suhas V

Hi, Check this post in my blog: http://thebipalace.wordpress.com/2011/02/03/search-for-objects-in-sql-server-databases/Please mark as answer if this helps. Thank you. http://thebipalace.wordpress.com

You can simply use the Data Export Import Wizard to do that and save the resulted as a package to run later at any time.Arthur My Blog

Hi, Check this post in my blog: http://thebipalace.wordpress.com/2011/02/03/search-for-objects-in-sql-server-databases/Please mark as answer if this helps. Thank you. http://thebipalace.wordpress.com

Same thread and it is answered .. http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/64d40cdb-75db-4bde-b583-cd643eb888dc/#f68ba84a-665e-41f4-a6c7-ea0a8c8ca6f0 Thanks, RajaSekhara Reddy . K

Once, I used one addd-in named Spire.DataExport. It is very useful to export data to text file or other format files. So, I want to introduce it to you. And it releases the free component. You can download the free version to check if it is really useful. You can download it from http://www.e-iceblue.com/Download/download-dataexport-for-net-now.html

Once, I used one addd-in named Spire.DataExport. It is very useful to export data to text file or other format files. So, I want to introduce it to you. And it releases the free component. You can download the free version to check if it is really useful. You can download it from http://www.e-iceblue.com/Download/download-dataexport-for-net-now.html