[Solved] Extracting SQL data to a new CSV file. - VisualCron - Forum

Community forum

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.
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!
jason.love@willbros.com
2013-12-13T13:17:14Z
Thank you, that worked perfectly!
Scroll to Top