SSIS Packages

SSIS Package: CreateOtherPackers.dtsx
This package is a 'sister' to the Bulk, Finished builds.  In all cases, these tools reformat the data so as to display it in the Inventory Spreadshe...
Tue, Sep 8, 2020 10:55 AM
SSIS Package: Grower_Accounting_upload 1.dtsx
I believe this is a duplicate of a package in the root of SSIS.   I'm skipping it as I do not believe this one is current.
Tue, Sep 8, 2020 11:13 AM
SSIS Package: SendTransferChangeNotifications.dtsx
This tool sends messages out to the impacted DOCKXX.   This package seldom needs adjustment although it does filter on TCF warehouses).   The package append...
Tue, Sep 8, 2020 11:31 AM
SSIS Package: ProcessHandHelds & Lake O's upload process for OLD hand helds
Lake O uses old batch hand helds for row location inventory because newer ones are not cold tolerant.   We do not have source for the programs, they have wo...
Fri, Sep 11, 2020 12:22 PM
SSIS Package: OnOffHolds.dtsx
This package is the primary processor for product being placed on or off hold.   The Quality Management app allows users to put a group of totes on (or off)...
Tue, Sep 8, 2020 12:35 PM
SSIS Package: UpdateSafetyStock.dtsx
UpdateSafetyStock is called by the scheduled task "Refresh Safety Stock". Safety Stock is a concept where a predetermined inventory level in...
Tue, Sep 8, 2020 12:49 PM
SSIS Package: Load_year_percentages.dtsx
Unknown if this is used for any purpose.  I don't find a scheduled task so I do not see where/how it would be run. It builds the en_lot_pct table....
Tue, Sep 8, 2020 1:32 PM
SSIS Package: SalesOrderNotifications.dtsx
This package formats a HTML document and emails it out to the appropriate docks.    This is considered to be a critical notification used by the docks...
Fri, Oct 30, 2020 7:45 AM
SSIS Package: UpdatePalletTracking.dtsx
This tool will add records to the pallet_ tracking table.   It is based on an entry on the load extension table (so_load_ext) where pallets have been identi...
Fri, Sep 11, 2020 1:13 PM
SSIS Package: Post_to_en_lot_ext (1).dtsx
There are a number of pieces of information about totes (such as day code) that are stored in en_lot_ext (user extension table).   These are written to a ta...
Fri, Sep 11, 2020 1:43 PM