SSIS Components for USPS

Build 20.0.7587

PickupAvailability

Checks availability for courier dispatch service for an address. This should be used prior to executing SchedulePickup in order to ensure the service will be available. The output values are not stored internally.

Procedure Specific Information

The stored procedure will examine the following tables for input:

  • Senders

Execute

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

EXECUTE PickupAvailability SenderId = 3

Input

Name Type Description
SenderId Integer Identifier for the Sender requesting pickup.

Result Set Columns

Name Type Description
ShipDate Date Date package will be mailed.
CarrierRoute String The carrier route. This can be

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