Report directely with SSIS Package

• nkm129

  SSCommitted

  Points: 1763

  More actions

  August 25, 2008 at 12:52 am

  #123054

  Hi,

  Could it be possible that instead of transfering data in any staging table , this package itself become a source of reporting system?

  Thanks!

• Dave Klug

  SSCertifiable

  Points: 5811

  More actions

  August 26, 2008 at 6:21 am

  #863056

  Yes, SSIS packages can be a source for a SSRS report. There's an MS article here on the subject http://msdn.microsoft.com/en-us/library/ms345250.aspx.