Posted: 4/25/2012
Can anyone please help me with the following problem?
I have a table created by an earlier developer on the DEV SERVER and i want to know which PACKAGE was used to create the table? Is there any step by step process where i can locate the PACKAGE that the table is connected to , please need help.
Thanks
How many packages do you have? If you want some really cool, detailed, monitoring of your SSIS enviornment I recommend you check out BIxPress*. Just apply the auditing framework to the packages (don't worry, it's easy to add/remove it). Once you do that (and create the auditing databases from the tool), you'll be able to monitor all your packages. You get information such as runtime, rowcounts, performance trending, bottlenecks, etc.
*Disclosure: I work for Pragmatic Works