Debugging Visual Basic (VB) COM DLLs that you use in DTS is easier than it sounds.
Create a reusable project that periodically downloads and processes Web data.