Solved

Last successful run date

Posted on 2016-09-28
2
29 Views
Last Modified: 2016-10-13
Is there something built into SSIS that would give me the last successful run date for the package?
0
Comment
Question by:vbnetcoder
2 Comments
 
LVL 14

Accepted Solution

by:
Megan Brooks earned 500 total points
ID: 41820932
If you are using SQL Server 2012 or above and running packages from the SSIS Catalog (SSISDB), that information is automatically recorded. You must, however, deploy your packages to the catalog and run them from there.

Otherwise you can create an SSIS log table (sysssislog) and configure packages to log to it (you choose the events to log) using the SQL Server log provider. The support for sysssislog is built in but not configured automatically. You can also log to other media - see Integration Services (SSIS) Logging.
0
 

Author Closing Comment

by:vbnetcoder
ID: 41842125
ty
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SSIS Child Packages get opened when being executed. 2 58
SQL Job Error in SSIS Package 2 74
Executing multiple ssrs reports from ssis package 20 52
SSIS currency format 5 55
Sometimes, you need to use PIVOT in SSIS to ensure your data matches the output requirements of your users. So, what is PIVOT and what is SSIS and how can that help ? Firstly a quick explanation of those acronyms as described by Microsoft :   M…
My client sends data in an Excel file to me to load them into Staging database. The file contains many sheets that they have same structure. In this article, I would like to share the simple way to load data of multiple sheets by using SSIS.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question