SSIS Components for USPS

Build 20.0.7587

SchedulePickup

Schedules a courier pickup from a specified sender's location. Input information will, at a minimum, be gathered from the Senders table. While the ConfirmationNumber is displayed immediately, this value will be inserted alongside other pertinent values in the Pickups table automatically.

Procedure Specific Information

The stored procedure will examine the following tables for input:

  • Senders

The stored procedure will add its output as records to the following table:

  • Pickups

Execute

In order to execute this procedure, one must specify SenderId, and TotalWeight. See the example below:

EXECUTE SchedulePickup SenderId = '3', TotalWeight = '13.37'

Input

Name Type Description
SenderId Integer Identifier for the Sender requesting pickup.
TotalWeight Integer The estimated weight for the packages to be picked up.
ExpressCount Integer The number of Express Mail packages to be picked up.
PriorityCount Integer The number of Priority Mail packages to be picked up.
InternationalCount Integer The number of International Mail packages to be picked up.
OtherCount Integer The number of mail packages to be picked up, outside of Priority/Express/Intl.
PackageLocation String A description of the location of pickup.
SpecialInstructions String Special instructions for pickup location, if any.

Result Set Columns

Name Type Description
PickupId Integer Identifier for the pickup request.
ConfirmationNumber String Confirmation number for the pickup request.
ShipDate String Date that the package will be tendered.
CarrierRoute String The carrier route. This can be
SenderId String Identifier of the sender requesting the pickup.
TotalWeight Integer The estimated weight for the packages to be picked up.
ExpressCount Integer The number of Express Mail packages to be picked up.
PriorityCount Integer The number of Priority Mail packages to be picked up.
InternationalCount Integer The number of International Mail packages to be picked up.
OtherCount Integer The number of mail packages to be picked up, outside of Priority/Express/Intl.
PackageLocation String A description of the location of pickup.
SpecialInstructions String Special instructions for pickup location, if any.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587