|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, October 28, 2008 10:32 AM
Points: 1,
Visits: 4
|
|
We wanted to automize the output of a sql server query to store it as .csv or .xls output in the specified location of c:\.
Kindly help us out in sorting this issue out, so that we do not want any manual intervention of selecting options in T-SQL, as we want this to be done as part the query command.
Thanks to all for this help!
|
|
|
|
|
SSC-Enthusiastic
Group: General Forum Members
Last Login: Thursday, June 04, 2009 7:26 AM
Points: 192,
Visits: 282
|
|
hi
The simplest answer would be to use SSIS.....
There are ways in SSIS to dynamically create the file names etc.
Then create a job with the execution schedule you require
|
|
|
|
