January 14, 2016 at 11:01 am
I am pretty sure I am on the right track but hit a wall.
I have 2 different SQL servers, one of them has a bunch of tables that are refreshed every 2 hours. We can not connected directly to those sources, instead we have to move the data we want off to another location, which we have in another server and database we have set up for just that purpose. The underlying issue is that the structure can change, so when I move the tables I have to drop the existing ones and recreate them.
In a control flow I have created a SQL Task to pull the list of tables that I want
I then created a foreach loop container iterating through all of the tables User::TableName
Inside the container I added another Execute SQL task where I drop each table if it exists
I then linked that to a data flow task , here is where the wall is.
I think I should be able to create and Olesource and set the dataaccess mode to table name or view name variable and then create and oledestination, I was hoping I could set it to create but no matter how I configure it I just can not seem to get there.
HELP
January 14, 2016 at 12:04 pm
Manually recreating your source and destination to accommodate the changes should be no problem. Having the package do it automatically at runtime is basically not possible.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply