This package is called by the hand held shipping application to post the records from the file .zz_hhtrans_tbl (which is written by the usage hand held program) and will post the results to the TEE Engine.
The SSIS package is passed a file name (which is generated by the hand held shipping code), which queries the file with a key matching and writes the records to \\vap01\VAP01E\einterface\Inbound\New\
Any .eif files in this location are picked up and processed by the TEE Engine.
Rarely, it is necessary to manually call this package, but I stress it is very rare. To do so, query the database and find the file name and update the parameter, then run the package. In the example below, simply replace the xfr….eif with the file_name from zz_shippping_detail_tbl and run the package.
In very cases, you may want to edit the uploaded contents of the file. The data is a copy of each line destined for the TEE engine, so it is possible to change the uploaded data, such if they uploaded information with an incorrect transfer number (or similar). Remember to delete the .eif file of the same name from VAP01 first or it won't post.
Summary:
Edit the records in zz_shippping_detail_tbl.
Copy the filename from the zz_shipping_detail_tbl and past it into the parm on the SSIS package
Delete the existing file from VAP01\Einterface (if there is one)
Execute the package