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