DEPRECATED: Starting with SSIS+ 1.9, the .NET scripts are no longer maintained. Use the provided JavaScript alternative scripts instead.
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