Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Using VB.Net to search DTS packages that contain references to MS Access data sources

Posted on 2009-05-14
2
Medium Priority
?
292 Views
Last Modified: 2013-11-07
Hi

I want to get a list of DTS packages from SQL Server 2000 that contain references to MS Access datasources (i.e. load data from MS Access into a table, or otherwise manipulate MS Access data). The system I'm working with has many hundreds of DTS packages and I don't have the time to manual inspect them all.

To date, I have discovered how to use VB.Net to get a list of DTS Packages and scheduled DTS Jobs, but the ability to view the internal workings of DTS packages escapes me. Can someone provide me with code that I can use to extract such data in VB.Net please.

This is extremely urgent.

Cheers

Andy
0
Comment
Question by:andrewstobirski
[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 Comments
 
LVL 96

Accepted Solution

by:
Bob Learned earned 1500 total points
ID: 24394461
I would think that it might be easier to use something already created:

DTS Documenter for SQL Server 2000
http://download.cnet.com/DTS-Documenter-for-SQL-Server-2000/3000-10254_4-10426275.html

If you still need to find a way to do that with SQL Server 2000 DTS packages in your code, that sounds like a challenge I would be willing to participate in.  I do not have the specific answer, but it sounds useful to me to help you find a way.
0
 

Author Comment

by:andrewstobirski
ID: 24409947
Hi TheLearnedOne

Thanks for replying to my question: the package you recommended proved to be very helpful and solved some of my other problems, which I was planning to ask at a later date.

As for the MS Access question, in the end we found some old documentation which narrowed down the search, and due to deadlines performed a manual inspection.

Cheers

Andy
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

This article describes relatively difficult and non-obvious issues that are likely to arise when creating COM class in Visual Studio and deploying it by professional MSI-authoring tools. It is assumed that the reader is already familiar with the cla…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…

721 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