Might be to do with the disclaimer, can you try it without or try the code as below?

EXEC msdb.dbo.sp_send_dbmail

@recipients = 'snmsheik@rsi.ramco.com',

@subject = 'My Mail Test',

@body = 'Database mail Test'

Hi

I have just ran you code throught our system and got the email without any problems, What email server are you using to send the email and what app are...

Hi Grass

I normally use create table and import it using OPENDATASOURCE.

(SAMPLE)

INSERT INTO IMPORTDATA

SELECT *

FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', 'Data Source=[File location]\;Extended Properties="Text;HDR=No;FMT=Delimited"')...TEXT#csv (your csv filename, replace...

Hi,

Why not run your TSQL with OSQL command;

OSQL -E -S{servername} -d{databasename} -q{your TSQL}