please need help in tracking a package for a table

Who is online?  0 guests and 1 members
Home  »  Forums   »  microsoft business intelligence   »  integration services   » please need help in tracking a package for a table

please need help in tracking a package for a table

Topic RSS Feed

Posts under the topic: please need help in tracking a package for a table

Posted: 4/25/2012

Jedi Youngling 14  points  Jedi Youngling
  • Joined on: 4/16/2012
  • Posts: 7

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


Posted: 4/25/2012

Jedi Knight 2272  points  Jedi Knight
  • Joined on: 2/22/2010
  • Posts: 201

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


Page 1 of 1 (2 items)