question

I am writing a package that goes to a database on a server (set by variables) and copies required tables back to my local database ready for future processing. The package needs to be completely dynamic so that you can run it on any database on any server. THe list of required tables is held in a table on my staging database. I wrote the package using the "Transfer SQL Server Object task" within the script task and this works perfectly except for one table, that has a computed column based on a function. My initial work around was to copy the function to the staging database which means that my package now works however as the package does need to be dynamic, it will break if someone else puts a function on a computed column. I then created a script to go and get the table structure and create the table on my staging database, which works successfully, my problem is getting the data. I can't get the data flow task to work with the tablename coming from a variable, I can't get the execute sql task to use the variable and I'm struggling to get the results out via the script task. Can anyone advise. My workaround may not be the best idea so if there is a different way of doing the same thing that's also great. Many thanks