November 30, 2011 at 9:02 am
I have an SSIS package that:
1. Deletes an existing Excel file.
2. Creates a new blank Excel file.
3. Uses a Data Flow Task to move data from a SQL Server table to the Excel file.
4. Does some minor changes to the Excel file.
5. Sends an email to a bunch of people telling them the Excel file is ready.
I have deployed the SSIS package through traditional means to SQL Server. I see the SSIS package has been deployed as a stored package. When I run that stored package, it works as it should.
Then I created a SQL Agent job to run the stored package. SQL Agent says it ran the package without error. However, when I look at the Excel file, I see that it has not changed. Also, no email was sent.
Is this a permissions issue? Is there something wrong with how I deployed the package? Why are there no error messages for me to investigate?
November 30, 2011 at 9:33 am
CORRECTION: the SQL Agent job can create the file, but does not send the email. Are special permissions needed for a SQL Agent job to execute the SSIS Send Mail Task?
November 30, 2011 at 9:42 am
imani_technology (11/30/2011)
CORRECTION: the SQL Agent job can create the file, but does not send the email. Are special permissions needed for a SQL Agent job to execute the SSIS Send Mail Task?
It depends on what you use as the SMTP server. Some SMTP servers are configured to not allow a user to send email as another user (different sender email address), and some do not allow you to send anonymous emails.
You shouldn't be looking at the SQL Agent logs alone. Are you making use of logging within the SSIS package? What does the SSIS logs show?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply