Exec msdb.dbo.sp_send_dbmail (zipped and password protected) issue

Question

Post reply

Exec msdb.dbo.sp_send_dbmail (zipped and password protected) issue

Pyman

SSChampion

Points: 13830
More actions
June 12, 2013 at 2:42 pm

#295168

Is it possible to send a csv file password protected and zipped and sent with msdb.dbo.sp_send_dbmail?
“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Sean Pearce SSCoach Points: 15999 More actions · Answer 1

EXEC msdb..sp_send_dbmail

@recipients = '',

@subject = '',

@body = '',

@file_attachments = 'C:\my_csv.zip';

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]

Pyman SSChampion Points: 13830 More actions · Answer 2

password protected?

“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams

Sean Pearce SSCoach Points: 15999 More actions · Answer 3

Sapen (6/13/2013)
password protected?

Password protection of zip files is a function of the zip software you use before sending the email.

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]

Steve Jones - SSC Editor SSC Guru Points: 734564 More actions · Answer 4

You could use encryption in SQL Server 2008 to encrypt the data before it's exported to the file. however if you are attaching a file dropped on your file system, you'd need to encrypt it with a command line or use password protection as part of the zip process.