Solved

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

Posted on 2009-05-14
2
266 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
2 Comments
 
LVL 96

Accepted Solution

by:
Bob Learned earned 500 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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

810 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