No votes yet


Overview

Data flow source, retrieving PayPal transactions information.


Setup

The script has the following parameters:

  • ServerType - selects server type: Production, Sandbox.
  • User - specifies user name.
  • Password - specifies password.
  • Signature - specifies PayPal service access signature.
  • GetDetails - indicates whether transactions details are retrieved.
  • IsStartDateVariable - indicates whether the start date is stored in a variable.
    • StartDate - specifies start date.
    • StartDateVariable - selects variable containing start date.
  • IsEndDateVariable - indicates whether the end date is stored in a variable.
    • EndDate - specifies end date.
    • EndDateVariable - selects variable containing end date.
  • TransactionClass - selects what class of transactions to retrieve.
  • Status - selects transactions with what status to retrieve.
  • Other - specifies other transaction search parameters. Separate multiple parameters with newline.

Requirements

Depends on COZYROC Script Component Plus for implementing parameters user interface.


Library references

  • System
  • System.Data
  • Microsoft.SqlServer.TxScript
  • Microsoft.SqlServer.PipelineHost
  • Microsoft.SqlServer.DTSPipelineWrap
  • Microsoft.SqlServer.DTSRuntimeWrap
  • Microsoft.SqlServer.ManagedDTS
  • CozyRoc.SSISPlus
  • System.Web

ScriptMain