May 2, 2013 at 12:09 pm
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?
Thanks - Bill
May 2, 2013 at 9:48 pm
bill-900846 (5/2/2013)
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:
SELECT *
FROM sys.table_types
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.
HTH,
Rob
May 3, 2013 at 9:30 am
It was the latter. I used the brute-force method. Saved as XML, opened in UltraEdit text editor, and did a search to find the appropriate lines that listed the tables.
Robert, thanks for the reply.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply