I am not too certain when you said "few export file will not have any rows at all" in the original message by Mohan. Does this mean the job created...

I know this is very silly question but could you PING to the 64 bit machine from the 32 bit machine? Because I could not find any other suggestion.

It's on going issue for everybody who transforms number string to csv format. But if you do not mind to have double quotes at the beginning and end of the...

Try

 Exec Master..xp_sendmail  @recipients = @Precipients

        ,@message = @Pmessage

        ,@query = @Pquery

         ,@attachments = 'Data.xls'

         ,@subject = @Psubject

         ,@attach_results = 'TRUE'

         ,@width = 9999

         ,@separator = @sepchar

         ,@dbuse = @DBName

Obviuosly...

Use this link:

http://sql.codebetter.com/blogs/raymond.lewallen/archive/2005/05/04/62781.aspx

Or for text file:

Use

EXEC master..xp_cmdshell 'osql.exe -S Server -U sa -P password -d database -Q "Select * From test" -o "C:\output.txt"'

This normally happeds when DTS lost workflow order.

Right-Check on all the workflows one by one then select Workflow Properties.

You will find one of the work flows lost Source Step. This happened...