andrewstobirski
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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