Software

Question

Locked

Ignore or eliminate ODBC messages in output of the scheduled SQL Agent job

By zsoltfodor ·
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!!!!

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums