BEGIN:VCALENDAR
PRODID: 1
VERSION:2.0
METHOD:PUBLISH
X-WR-TIMEZONE: America/Los_Angeles
DTSTAMP: 20260701T020920
BEGIN:VEVENT
UID: info@vconferenceonline.com
SUMMARY:SSIS Packages – Data collection with For Loop
PRIORITY:0
CATEGORIES:SESSION
CLASS:PUBLIC
DTSTART:20170502T120000
DTEND:20170502T131500
URL: https://event.vconferenceonline.com
DESCRIPTION:SSIS packages are excellent tools for data gathering from multiple sources. In an environment where a COTS database is being managed for multiple clients. Data collection for enterprise level data marts and reporting.<br />
<br />
Environment: SQL 2014 Enterprise<br />
<br />
There are five database instances that have ten databases housed on each. Each database is schematically the same and kept in sync at the DDL level. These databases are used for separate facilities to stored and manage that site&rsquo;s data. Each facility is separate from the others and no interaction occurs. Each facility is related and under the direction of a controlling entity. That controlling entity needs to be able to report on data and investigate information from a high level view.
LOCATION:
END:VEVENT
END:VCALENDAR