Hi all,
In my project we are writing around 150 DTS package. Everytime we make any
small modification to any of these DTS package, we have to test all these 150
packages. Testing all teh scenarios for all the 150 packages is time
consuming.

I would like to automate the testing of the DTS package to some extend. Some
scenarios which can be tested as common test case for all teh packages can be
1. test for access rights
2. test if the flow in the package is valid
3. test for error scenarios like source not found etc.

Can someone suggest me on how to automate these kind of generic testing that
I will be doing. This will save my time in testing.

Thanks
GS

Hello GS,

Can you not load the packages names into a table or file and then have a
piece of code that runs through that list and executes the package.

The package will error if there are no access rights to a connection
If the package goes from Start to finish with no errors then the data flow
worked.
Your package can check for "Source Not Found" and can direct the workflow.
This will alllow you to determine of things were valid.

Your calling program can then check each step of the executed package and
find out what happened.

Allan