Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


  1. Forum
  2. Support
  3. General problem solving
  4. [Solved] Extracting SQL data to a new CSV file.
jason.love@willbros.com
2013-12-11T15:46:04Z
What is the best way to export data from SQL Server to a CSV?

I need to setup daily extracts that will export data from 3 views I have created into 3 new CSV files each and every day. The job will need to create the flat file and then extract the data to the new flat file.

Please assist.
 Reply
 View All Posts by User
Sponsor
Forum information
Support
2013-12-12T14:35:21Z
1. use the SQL Task, go to output tab of that Task and change field separator to comma
2. create file write task, write output of previous Task by using this Variable in the value field:

{TASK(PrevTask,StdOut)}
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
 Reply
 View All Posts by User
jason.love@willbros.com
2013-12-13T13:17:14Z
Thank you, that worked perfectly!
 Reply
 View All Posts by User
Similar Topics
Users browsing this topic
  1. Forum
  2. Support
  3. General problem solving
  4. [Solved] Extracting SQL data to a new CSV file.
 

© SMA Technologies. All Rights Reserved, 2024 Version: 11.1.26.176dac7

Privacy Policy
Terms & Conditions
Sitemap
Scroll to Top