Solved

sql ssis execution details msdb

Posted on 2012-03-27
2
340 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
  • 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

813 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

16 Experts available now in Live!

Get 1:1 Help Now