Solved

sql ssis execution details msdb

Posted on 2012-03-27
2
342 Views
Last Modified: 2012-04-25
I have ssis packages on Server A. I think they are on the file system. Some of them might run against server B. Is there a table in MSDB on server A which shows the details of packages executed.. and if they executed a proc on server B or used a table on server B?

My question actually is I think most/all of the SSIS packages are at the file system on Server A. I needed a simple way to know if any of them have any connection/usage of server B. I was hoping msdb on Server A might have the details instead of opening all packages.
0
Comment
Question by:sqlserverdba
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
ID: 37774613
I was hoping msdb on Server A might have the details instead of opening all packages.
No, there is nothing to in msdb to relate to SSIS packages saved as files.  In fact the files could be stored on any server and there could be packages with connections to both servers.  Your best bet is to write an app to search all the packages for the information you need.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 37894692
I am sorry you did not like my answer and that you had to wait a month to accept it.
0

Featured Post

Major Incident Management Communications

Major incidents and IT service outages cost companies millions. Often the solution to minimizing damage is automated communication. Find out more in our Major Incident Management Communications infographic.

Question has a verified solution.

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

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
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.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

751 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