How can you list the tables transferred in an SSIS Package?

  • 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

  • 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

  • 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