Dynamic Connections

I have read the posts on dynamic connections and still am not able to get it to work. Sorry, but I need specific instructions. I know it has something to do with the For Each Loop container, and something with the package variable, but I need more instruction.

What I am trying to do is transfer data from several (86) servers to a central server (all SQL Servers). The many servers will have the same code run against them to gather data and transfer it to the central server. I have written a package with those two objects for each server, but I know that there has to be a way to create just those two objects with the connection of the first object being dynamic and just looping through some type of list.

I hope my explaination is clear.

Thanks,

Peter Cwik

This is a fairly step-by-step guide: http://blogs.conchango.com/jamiethomson/archive/2005/05/30/1489.aspx

If you're getting errors - let us know the error messages.

-Jamie

|||

I've tried that, but it uses a flat file source file. I have a SQL Server source. There is enough difference that I cannot transfer the knowledge from one to the other. The settings and what not are too different. I need specific instructions, just once.

Pete