Creating a new text/csv file everytime exporting a data in SQL server 2005

• vishal.hatvalne

  SSC Enthusiast

  Points: 193

  More actions

  February 11, 2009 at 9:30 am

  #130811

  Hi,

  Does anybody have idea how I can export data from SQL Sever to text file. I want to make new text file every time I export data.......????

  Thanks in advance.

  Vishal

  :):):)

• Ramesh Saive

  SSC-Insane

  Points: 24275

  More actions

  February 11, 2009 at 9:39 am

  #942289

  ...Simple, need 1 Data Flow Task, 1 SQL Connection & 1 Flat File Connection

  --Ramesh
  

  ---