Solved

Last successful run date

Posted on 2016-09-28
2
23 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
In couple weeks ago, I encountered an extremely difficult problem while deploying 2008 SSIS packages to a new environment (SQL Server 2014 standard).  My scenario is: We have one C# application that is calling 2008R2 SSIS packages to load text fi…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

911 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now