We are successfully using this task.

We have downloaded it from here, http://ssissftp.codeplex.com/

And then read below documentation on how to register dlls to use it inside package.

http://ssissftp.codeplex.com/documentation

This...

My code is working but its sending thousands of emails for 1 event. Isn't that abnormal?

When I use this,

IF ORIGINAL_LOGIN() LIKE '%user' OR ORIGINAL_LOGIN() LIKE 'ssis%' OR ORIGINAL_LOGIN() LIKE 'bo%'

After then when application user logs in, it throws error which I don't want.

So instead I...

Where exactly I said its 2014? I don't remember but if I said I m so sorry.

And I put it in 2008 becuase 2005 and 2008 are still very similar...

Thanks but unfortunately we r still on sql 2005 server and this feature is not there.

Thnaks but in the same thread if you go to page-3, U will see my code which says, and i still have issues.

--SELECT * FROM sys.dm_exec_sessions order by login_time desc

USE...

I tried this code but seems like something is wrong and it generated more than 2500 emails just for 1 event that I tested.

USE [msdb]

GO

-- Create a queue

CREATE QUEUE Q_Logon_Triggers_Queue;...

Thanks but thats not what I aksed, I need an email when this activity happens and I dont want them to stop from logging. If u go back to page-3...

Thanks but its not working the way it should work. Its bringing false emails. And instead of user name it brings DOMAINNAME\LOGINNAME that I put inside EXECUTE AS 'DOMAINNAME\LOGINNAME'

I am...

Thanks but still its throwing the error message.

I tried it but its giving me error.

ALTER TRIGGER [TR_LOGON_APPUSER_SSMS]

EXECUTE AS OWNER

Hi Instead of throwing error message from script can I send email only to dba saying this user tried to logon from ssms? Dont throw error and allow them to...

Yeah it has maintenance clean up task after db backup but when u check history it says backup completed in 2 hrs.

Yeah its same location with lot of space available. Everything is same.

Here is further error description:- Description: Failed to load task "SFTP Task", type "". The contact information for this task is "cosmin.vlasiu@gmail.com".

When I right click SSIS package...