March 11, 2011 at 4:14 pm
i have table called table1 which is being populated by some X SSIS package,now i need to find that package and check how its is being populated.i have around 700 packages...any suggestions please reply
March 11, 2011 at 4:27 pm
You have a few options that can help you.
You can use SQL Profiler to monitor that database/table. The connection string the SSIS package uses should be part of the information that Profiler captures, and may contain enough info to lead you to the package. 2008+ connection strings include an "Application Name" setting on the connection manager that includes the package GUID by default.
You can try to search your package repository manually using any text-search tool. The name of the table will be stored in plain-text in the packages, whether they're on the file system, or in msdb.
Todd McDermid - SQL Server MVP, MCTS (SQL 08 BI), MCSD.Net
My Blog - Dimension Merge SCD Component for SSIS - SSIS Community Tasks and Components
March 11, 2011 at 7:59 pm
When the SSIS packages are stored to disk, they are stored as .dtsx files. These are XML files, so with a little bit of investigative work, you can write a query that can shred all of the XML, looking for the table that you're interested in.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply