SSIS Package to Report Metrics

  • Is it possible to create an SSIS package that can simply display the size of the data files of all databases on an instance? I've been working with a foreach loop container with the foreach SMO enumerator to enumerate database names. It loops through each database but the output to an excel file shows the results of a single database multiple times. Does anyone have any suggestions?

  • Why not just use a Data Flow and use the sp_HelpDB stored procedure as the data source?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply