Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
stev1ef
Starting Member
3 Posts |
 Posted - 2010-09-09 : 08:18:48
|
| Guys,First of all I'd like to say thanks, I posted a thread a few days ago - it was responded to promptly and it solved my problem with a few tweaks.Now I have the script I need to produce the report I need. However my customer wants to automate it so that an ANSI .csv file is produced when runnng the file.I have tried to create a job to do this for me and laboured with my efforts for most of yesterday but no further in my achievement of this goal.Can one of you knowledgable selves let me into the secret of satifying this requirement?Many thanks |
|
|
MSquared
Yak Posting Veteran
52 Posts |
Posted - 2010-09-09 : 12:19:56
|
| There are a number of ways that this can be achieved. You can BCP out the file with a format card, you can run a sql script with xp_cmdshell, you can create an SSIS package. How is this going to be automated? through SQL Agent job?For Faster results please follow the posting guidelines herehttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
 |
|
|
|
|
|
Producing an ANSI csv file from a query.