Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SSIS logging

Posted on 2014-11-03
3
Medium Priority
?
52 Views
Last Modified: 2016-06-15
I find that there are some SSIS logging stored procedure and tables created on a SSIS project. Is there a standard package or bulit-in component on SQL 2008 to generate them ?


Tks
0
Comment
Question by:AXISHK
2 Comments
 
LVL 66

Accepted Solution

by:
Jim Horn earned 2000 total points
ID: 40419394
>Is there a standard package or bulit-in component on SQL 2008 to generate them
Nope, in SQL 2008 it's completely 'roll your own', i.e. any logging is custom made by the developer.
SQL 2012 is the first version that ships with SSIS logging, look in the SSISDB database.
0
 

Author Comment

by:AXISHK
ID: 40423256
Any guidellne on setting up the SSIS logging on SQL 2012 ? Tks
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

581 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