Solved

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

Posted on 2009-05-14
2
247 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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
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…
This video discusses moving either the default database or any database to a new volume.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

757 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

19 Experts available now in Live!

Get 1:1 Help Now