Rookie SSIS user on SQL2008R2. I need to list the names of the approximately 95 tables that are moving from one DB to another. Is there a simple way to do this?
Are you looking for a list of all tables in the db? If so you can just do something like:
If you want to see what tables the SSIS package is working on, you need to open the package (.dtsx file) and take a look. It could be looping through a result set taken from a query like above, it could be hard coded -- you'll just need to see what the package is doing.