SSIS Components for Blackbaud Raisers Edge NXT

Build 21.0.7930


Returns a list of gift batches.

Table Specific Information


The component will use the BlackBaud Raiser's Edge NXT API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the component.

  • BatchNumber supports the '=' operator.
  • CreatedBy supports the '=' operator.
  • HasExceptions supports the '=' operator.
  • IsApproved supports the '=' operator.
  • SearchText supports the '=' operator.


Name Type References Description
Id [KEY] String The batch identifier.
ActualAmount Integer The actual batch amount.
BatchDescription String The batch description.
BatchNumber String The batch number.
CreatedBy String Created by user name.
CreatedOn Datetime The date the batch was created.
HasExceptions Boolean The has exceptions boolean.
IsApproved Boolean Approved boolean.
NumberOfGifts Integer The number of gifts in the batch.


Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
SearchText String If set to true, includes inactive gift batches in the result.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930