Home Forums Reporting Services Reporting Services Design Question: What is the best practice for reporting on data that spans instances? RE: Design Question: What is the best practice for reporting on data that spans instances?

  • I'm not sure if this helped or not (because I found some additional links posted below at about the same time), but the description matched my error and the syntax was hard to find. So, I thought I would post it in case it may be useful to someone in the future.

    http://www.lifeasbob.com/2008/07/31/DestinationConnectionExcelAndOfflineMode.aspx

    The NT-DOS syntax (which requires Admin rights) for SQL Server 2012 at our site is:

    %windir%\syswow64\regsvr32 "C:\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\dts.dll"

    However, I finally got an SSIS loop to work across instances with the following two links:

    http://thesqldev.wordpress.com/2013/02/20/iterate-over-databases-using-ssis-part-1/ (this page misses a step--you need to define *two* variables, "User::DatabaseName" *and* "User::DatabaseId", as readonly, not just one)

    http://thesqldev.wordpress.com/2013/03/23/iterate-over-databases-using-ssis-part-2/

    J