February 16, 2017 at 1:09 pm
My SSIS project, developed in Visual Studio 2012 under my Windows user account, includes two packages, SendMailOnly.dtsx and SendMailWithAttachment.dtsx. Both packages use a Script Task to send out an email. The first one has no attachment, and the second one has. Both packages run fine in my development environment.
The project is then deployed to SQL Server Integration Service Catalogs, on a network SQL Server. From there, the packages are called through a SQL Server Agent job using my windows account. The first package is executed successfully, but the second one failed. The error message stated that "Script Task Error: Exception has been thrown by the target of an invocation".
I did some researches online, and didn't find a solution. It seemed to be a user permission issue, however, how can I verify that? My Windows user account has read/write access to both SQL Server and the server where attachment file stored.
Please advise and thanks in advance.
February 16, 2017 at 1:13 pm
jay-125866 - Thursday, February 16, 2017 1:09 PMMy SSIS project, developed in Visual Studio 2012 under my Windows user account, includes two packages, SendMailOnly.dtsx and SendMailWithAttachment.dtsx. Both packages use a Script Task to send out an email. The first one has no attachment, and the second one has. Both packages run fine in my development environment.
The project is then deployed to SQL Server Integration Service Catalogs, on a network SQL Server. From there, the packages are called through a SQL Server Agent job using my windows account. The first package is executed successfully, but the second one failed. The error message stated that "Script Task Error: Exception has been thrown by the target of an invocation".
I did some researches online, and didn't find a solution. It seemed to be a user permission issue, however, how can I verify that? My Windows user account has read/write access to both SQL Server and the server where attachment file stored.
Please advise and thanks in advance.
Why is SQL Server agent using your domain account details, and not a domain service account?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
February 16, 2017 at 1:38 pm
Thanks for reply.
I'm going to ask our network administrator for advises. Also, can you recommend a few online references about domain service account?
February 16, 2017 at 2:22 pm
jay-125866 - Thursday, February 16, 2017 1:38 PMThanks for reply.
I'm going to ask our network administrator for advises. Also, can you recommend a few online references about domain service account?
Sounds like a question for the DBAs out there ...
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply