Unanswered: DTS - change OLE DB Connection - server & DB in Loop
I want to run Select SQL statement on different SQL servers & differett DBs
For this purpose I built DTS that in loop executes next operations :
1.get SQLServer Name and DB name from SQLTable
2. change DataSource and Catalog parameters of OLEDB Connection
( I try do it by Dynamic property Task and ActiveX Task)
3. Generate SQL Command and update SQLCommand Property
4. run DataPumpTask using this Connection and SQL command
My problem is that it's works fine only 1st time !!!
1st time DataPumpTask gets all changes and returns the correct value
but 2nd time it still returns value from Db of 1st step.
I see the changes in Connection, but DataPumpTask don't use the changed values.