I have a specified text format output file created in SQL Management studio, it has a corresponding result in it, but after I scheduled it via SQL Agent as a Job, the ODBC?
insert [SQLSTATE 01000] message after every row and ‘statistics’ in teh first row, so it looks like this (a part of the .txt)
Job ‘OLASGL_IF’ : Step 1, ‘OLASGL_IF’ : Began Executing 2007-05-17 14:52:41
1DE200702EUR559000009085463022000008999527463 [SQLSTATE 01000]
2C02010TWO 000000001327942- [SQLSTATE 01000]
2C04081FOU8PWA0000000265200000- [SQLSTATE 01000]
2C04122TWO 000000003435390+ [SQLSTATE 01000]
So how can I eliminate or get rid of these?
Please, Somebody help me! It would be very important because of the dedline of my task!!!!