This SSIS package reformats the finished goods inventory for the Inventory Spreadsheet. Like the sister SSIS package for Bulk, this one is self correcting by means of the finishetranstemp
file. It copies the file at the launch, if any errors, it rolls back to the copy.
In some situations, it may be necessary to assist by either deleting or creating the temp file. A review of the scheduled task history will indicate which is needed.
In most cases, the next time the job runs, it realigns itself.