[dba-SQLServer] Output to Text File

Mackin, Christopher CMackin at Quiznos.com
Mon Jul 12 18:36:55 CDT 2004


Hi,

I have a daily fixed width text file that I need to produce and I am currently generating it via VBA code, but am trying to post it to a SQL Job.  I have it set up to output to the proper file, the problem is that at the top of the file there is header info that I need to eliminate.  It looks like the following:

Job 'VPP' : Step 1, 'Create File' : Began Executing 2114-17-12 17:31:31

OutputLine                                                                      
--------------------------------------------------------------------------------
  813             212111132122111119987 111446349317132114                      
  813             212111132122111119988 111619832817132114  

Starting with the 813 is the data that I need in there, everything above needs to go, does anyone know how to do this?

Also, what other methods are people using to generate Text files from T-SQL?

Thanks,
Chris Mackin



More information about the dba-SQLServer mailing list