How is the Stimulus Set ETL run?

From Galen Healthcare Solutions - Allscripts TouchWorks EHR Wiki
Revision as of 03:11, 19 November 2011 by Steve.Stahr (talk | contribs) (→‎Answer)
Jump to navigation Jump to search


Regarding the Stimulus Set ETL:

  1. Is it an SSIS package?
  2. If not, what is it and where does it run from?


The SSIS packages execute from a server on the Allscripts network. Allscripts pulls the data from their central location to keep the footprint of the ETLs to a minimum on the source system. On the source server, SELECT statement will be seen running within SQL Server, but that is all.