SSIS Components for UPS

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 PackageId. See the example below:

EXECUTE SchedulePickup SenderId = 3, PackageId = '9,13,17'

Input

Name Type Description
IsInternational Boolean Whether the pickup will use the Intl service.

The default value is false.

ShipDate Date Date when package will be tendered. This value should be in the format (yyyy-MM-dd).
EarliestPickupTime Time Earliest time a shipment can be picked up. This value should be in the format (HH:mm:ss).
LatestPickupTime Time Latest time a shipment can be picked up. This value should be in the format (HH:mm:ss).
FloorNumber Integer Pickup location's floor number.
RoomNumber Integer Pickup location's room number.
SenderId Integer Identifier for the Sender requesting pickup.

Result Set Columns

Name Type Description
PickupId Integer Identifier for the pickup request.
ConfirmationNumber String Confirmation number for the pickup request.
EarliestPickupTime String Earliest time a shipment can be picked up.
LatestPickupTime String Latest time a shipment can be picked up.
PickupType String Pickup type as enumerated.
SenderId String Identifier of the sender requesting the pickup.
ShipDate Date Date when package will be tendered.

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