Export a group of tables into individual txt files

Hi all,
We have a group of 30 tables and these are updated on a daily basis i need to transfer the data loaded each day to each of these tables into corresponding text files... I wanted to know how can i achieve this.. we are working in MS SQL Server 2005
maverickgoon123Asked:
Who is Participating?
 
QPRConnect With a Mentor Commented:
SSIS
http://msdn.microsoft.com/en-us/library/ms141668(SQL.90).aspx

SQL query as the source and flat file as the destination
0
 
BinuthCommented:
use SQL jobs

"Microsoft SQL server management studio" >  "Object Explorer" > "SQL Server Agent" > "Jobs"
0
 
maverickgoon123Author Commented:
Hi thanks for the help... but i'm new to this could you explain how use SSIS
0
 
QPRCommented:
Everything you need to get started with SSIS.
http://www.microsoft.com/technet/prodtechnol/sql/2005/intro2is.mspx
When you get the hang of things go back to the first URL I posted so you can see how to export data to text files
0
All Courses

From novice to tech pro — start learning today.