Hopefully someone here might be able to help me out. I've been looking for examples on how to do this all day with no luck. I am creating an SSIS package to move data from a single table to multiple locations. I am updating data to 150+ stores. Each store has a network share I can access with no issue.
I know I can create a variable and place data in the variable to be used throughout the application. In my case, I need to read a record, get the ip from the record, construct the connection string using that variable (IP), execute the write. I know it can be done, I just have no idea where to start. I could use some help in a big way here. Examples or links to examples would be a great help. Thanks to anyone who can help in advance.