Tips and Tricks
- How to check SSIS Designer Version and Compatibility with Visual Studio / Perform Upgrade
- How to execute the store procedure and read output parameters using PostgreSQL ExecuteSql Task
- How to parameterize SSIS Task Property using Expression to make it dynamic
- How to use SSIS BDD Transform for parallel processing (Balanced Data Distributor - Split Rows in Multiple Threads)
- Zappysys XML destination is failing to handle boolean types
- When to use CURL vs SSIS ZappySys for REST API calls
SSIS Excel Source
SSIS Google Analytics Source
SSIS Salesforce Connection
SSIS Salesforce Source
SSIS Salesforce Destination
SSIS Dynamics CRM Connection
SSIS Dynamics CRM Source
SSIS Dynamics CRM Destination
- How to add /edit custom field in Dynamics CRM (e.g. Multi-Select PickList)
- SSIS Dynamics CRM Upsert Error - The entity key XXXXXX requires that this set of attributes contains unique values
- Dynamics CRM Update Error - Entity Id must be specified for Update
- Read / Write in SSIS Dynamics CRM for Lookup, Multi-Select PickList and PartyList data types
SSIS XML Generator Transform
SSIS Amazon SQS Destination
SSIS Amazon S3 Task
- Troubleshooting error: "encryption context for multi part upload not found"
- Troubleshooting error: "Connection is not specified"
- How to use IAM role for Amazon S3 related operations in SSIS / ODBC AWS Connection
- How to create folder in Amazon S3 Bucket using SSIS
- How to use KMS Encryption (Server side) in SSIS S3 Task
SSIS XML Source
SSIS REST API Task
SSIS Web API Destination
SSIS MongoDB Source
- How to Query MongoDB View in SSIS
- The Eval MongoDB command is not working on ZappysSys SSIS PowerPack
- Connect to PostgreSql, MySQL or MongoDB in SSIS using SSH Tunnel / Local Port Forwarding Technique
- Troubleshooting error: "Unable to authenticate using sasl protocol mechanism SCRAM-SHA-1"
- Troubleshooting error: "MongoServer.Create has already created 100 servers which is the maximum number of servers allowed"
SSIS Secure FTP Task
- SFTP Task Error - Invalid private key format
- SFTP ERROR - Invalid password or bad data (using Private Key)
- SSIS SFTP Connection - The connection was closed by the server - Failed on upload / download or middle of transfer
- FAQ About SFTP Task
- SFTP Zappysys Error message: Test Failed: Negotiation Failed. Disconnected by the server. Key Exchange failed.
- SFTP ERROR - RSA key (1023 bits) is weaker than expected minimum (1024 bits)
Common Errors and Workarounds
- Google BigQuery Connector Error-404: Not found: Job ga4-big-query-xxxxxx:job_xxxxx
- How to use Fusion Log to debug dll load issues in .net Application
- Troubleshooting S3 error - "We encountered an internal error. Please try again."
- Unable to cast object of type Newtonsoft.Json.Converters.XmlDocumentWrapper
- How to fix SSIS Error PerformUpgrade method failed - The component could not be upgraded to the newer version
- Could not load file or assembly 'ZappySys.Json'
SSIS Google Analytics Source
SSIS JSON / REST Source
- Error - Data Flow - System.Exception: Memory is locked - Random Error due to multicast and Large String (DT_TEXT blob type)
- How to capture URL / Error Message for SSIS Web API requests in Data Flow
- How to parse JSON data type data stored in SQL Server
- How to process 2D JSON Array without column names in SSIS
- How to see raw JSON coming from response in SSIS JSON Source Preview
- How to rename auto generated SSIS output columns in bulk
SSIS Advanced File System Task
General
- How can I include resource, scope, or additional attributes in the "get access token" call of a "grant_type=refresh_token"?
- The remote server returned an error: (429) Too Many Requests.
- Error: System.Exception: BufferException: Error: There is not enough space on the disk.
- In Visual Studio 2019 SSIS PowerPack components is missing in SSIS Toolbox
- Cannot see SSIS projects in Visual Studio 2019
- How to migrate SSIS PowerPack to a new server