Looping in DTS
I have an interesting DTS issue that I have not been able to find covered
I have a table that I query in DTS that gives me a list of queries to run
and the files to export them to.
I want to run this query from and activescript task and then for each row in
the task execute a transform to export the data.
The problem that I run into is that looping does not appear to be
straightforward once I leave the activexscripttask.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL