Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • 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
Tables
Tables

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

Image Added

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
Deployment
Deployment

...