Home > ETL Best Practices > Metadata Searching – SQL Jobs, SSIS, SSRS, and Procedures

Metadata Searching – SQL Jobs, SSIS, SSRS, and Procedures

Is your SQL environment growing so big and intertwined that your memory cannot tell you right away which SSIS package is populating which tables, and witch tables are used by which SSRS reports, and which SQL job is executing which SSIS package or procedure?  Welcome to the real SQL world!

A DBA in my group has built a few life-saving tables populated daily by a few very slick SSIS packages. Now I can search anything that my memory cannot reach.

The basic format he used is:

image

For searching a SSRS report, it’s a little less straightforward.

To be continued on this topic.

Categories: ETL Best Practices
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: