Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 183
  • Last Modified:

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
0
maverickgoon123
Asked:
maverickgoon123
  • 2
1 Solution
 
QPRCommented:
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

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now