Thanks for reading this post !
I need some assistance regarding the following:
SSIS package description: runs/performs all operations within BIDS. It uploads data to SQL from text,excel sources and performs all kinds of transformations. It also calls Stored Procedures. It has send mail task using SMTP as Event handler which uses an text (log) file as an attachment in case of error or task failed scenario to notify the admin.
Protection level- encrypt sensitive with user key
owner - domain account with sysadmin/local admin permissions
Problem: When scheduled as a SQL agent job, the package runs fine if there isn't any error. But, when there is an error and it tries to send e-mail with an attachment - it fails to do so.
Error: either the file(log) does not exist or you do not have permission to access it !!
SQL AGENT: Running under domain account with sysadmin/local admin permissions(different than owner)
I suspect the error is with user key protection level.
Can anyone throw some light on this and help me resolve this issue?
I'll appreciate your replies.
"The greatest ignorance is being proud of your learning"