Dear PhilPacha and Lowell:

Thank you for your answers.

I can confirm that:

1. using -c -r \r, I get only CR as row terminator

2. using -c -r , I get CR+LF as...

Hi PhilPacha:

Thank your for your answer.

However it does not work.

If I only use -r it does not copy anything and if I use -c -r I get again...

Thank you for the answer. But is there an option for just char(10) (Line Feed only) ?

Regards

Sorry everybody but perhaps an stupid doubt: I have not the tables msdb- sysdtspackagelog, sysdtssteplog, sysdtstasklog.

Is it possible?

Dear Mani:

Thank you for your answer.

I am not a very experimented user !!!

Both scripts you wrote do not run correctly. I get an error message related to the word "apply"....

Dear SanjayAttray:

Thank you for your answer.

I am not a very experimented user !!!!!

How can I identify the SPID of my Stored procedure?