patternsqlMinor
Export multiple tables among servers
Viewed 0 times
tablesamongserversexportmultiple
Problem
We currently have an SSIS package that exports about 70 large tables nightly, with truncate and load at the destination. Our tables keep changing, we sometimes add some tables and remove some and editing the SSIS package accordingly is tiring.
Is there a way to have a text file or a table with the list of table names in it and have an SSIS package to loop the table and perform the export? That way, it is easier to handle dynamic list of tables that get exported.
Any links, pointers are appreciated.
Is there a way to have a text file or a table with the list of table names in it and have an SSIS package to loop the table and perform the export? That way, it is easier to handle dynamic list of tables that get exported.
Any links, pointers are appreciated.
Solution
what you are looking for is to dynamically create tables in the destination.
or in other words Copying tables from Source to destination programmatically
here is a very useful article that transfers tables from access to sql dynamically
but you can take the same concept and apply it on your source as well.
https://stackoverflow.com/questions/6298806/how-do-i-programmatically-get-the-list-of-ms-access-tables-within-an-ssis-packag
or in other words Copying tables from Source to destination programmatically
here is a very useful article that transfers tables from access to sql dynamically
but you can take the same concept and apply it on your source as well.
https://stackoverflow.com/questions/6298806/how-do-i-programmatically-get-the-list-of-ms-access-tables-within-an-ssis-packag
Context
StackExchange Database Administrators Q#18228, answer score: 2
Revisions (0)
No revisions yet.