...
The queue proc, QueueExport
The configuration tables: PTG_ExportDeploy, PTG_ExportConfig, PTG_ExportQueue, PTG_ExportOut, PTG_ExportInstance
The SSIS Parametrized package: The package looks for the Active exports and generates the file. [PACKAGE NAME GOES HERE] ExportPackage.dtsx
Tables
| Anchor | ||||
|---|---|---|---|---|
|
PTG_ExportDeploy
...
ExportID: The ID for the export. (PTG_ExportDeploy)
...
dbo.QueueExport
The proc will start an InstanceID on PTG_ExportInstance which logs who queued the export.
It will then look through all the Active exports on PTG_ExportDeploy and insert a pointer for each active row into PTG_ExportQueue to be picked up by the export package upon job execution.
Package
...
This package is to be deployed as an Agent Job.
\TFS\Conversion\Integration_Pipeline\Export Job\ExportPackage.dtsx
Set Export ID: Gets the queued export rows from PTG_ExportQueue
Set Export File Variables: Sets table name for source data, file name, file path, sheet name for each export
Create Excel File: Is the C# script task that creates the file in the Folder system
Mark Exported rows: Removes the exported rows from PTG_ExportQueue and adds a row to PTG_ExportOut to timestamp the export as done.
Deployment
| Anchor | ||||
|---|---|---|---|---|
|
...