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

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
andrewstobirskiAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Bob LearnedConnect With a Mentor Commented:
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
 
andrewstobirskiAuthor Commented:
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
All Courses

From novice to tech pro — start learning today.