Tutorials

ODBC Tutorials All topics and questions related to ODBC will appear here. General questions about ODBC can be posted in this section and do not need to be ZappySys-related. This is a place where ZappySys Community members come together to help each other. The ZappySys Team will do its best to participate and ensure your questions are answered. SSIS Tutorials All the topics and questions about SSIS will appear right here. Any general questions about SSIS can go here and don’t have to be ZappySys-related. This is the place, where ZappySys Community members join together to help a fellow member. ZappySys Team will do its best to chime in and not leave you alone with your question.

Topic	Views	Activity
About the Tutorials category Tutorials	22	November 27, 2025
SSIS tutorial: writing headerless data to Excel at a specific starting cell SSIS Tutorials ssis-excel-file-dest , ssis-powerpack	9	October 2, 2026
SSIS tutorial: How to filter files by a numeric sequence or range using WHERE conditions SSIS Tutorials ssis-adv-file-system-task , ssis-powerpack	7	October 2, 2026
SSIS tutorial: How to build a bulk request body (JSON or XML) with Web API Destination's Batch Settings SSIS Tutorials ssis-web-api-dest , ssis-json-generator-tran , ssis-powerpack	10	September 24, 2026
SSIS tutorial: How to rename a file before moving it to keep a version history SSIS Tutorials ssis-adv-file-system-task , ssis-powerpack	7	September 24, 2026
SSIS tutorial: how to capture and store API success/error responses using Web API Destination SSIS Tutorials ssis-upsert-dest , ssis-json-parser-tran , ssis-web-api-dest	17	September 18, 2026
SSIS tutorial: How to use variables inside API source/destination SSIS Tutorials ssis-api-src , ssis-api-dest , ssis-powerpack	35	August 27, 2026
Convert a File to a Base64 String and Save it Locally as Text, JSON, or XML using ODBC CSV Driver ODBC Tutorials odbc-powerpack , csv-odbc-driver	42	July 31, 2026
SSIS tutorial: Identifying which rows were inserted or updated in SSIS SSIS Tutorials ssis-json-file-src , ssis-trash-dest , ssis-upsert-dest , ssis-powerpack	38	July 31, 2026
SSIS tutorial: How to filter files in the ZappySys SFTP Task SSIS Tutorials ssis-powerpack , ssis-sftp-task	35	July 31, 2026
SSIS tutorial: How to find the correct property name for SSIS expressions SSIS Tutorials expressions , ssis-powerpack , ssis-sftp-task	36	July 30, 2026
Encode a Local File as Base64 with FUN_FILE_BASE64ENC using ODBC PowerPack ODBC Tutorials odbc-powerpack , csv-odbc-driver , api-odbc-driver , jdbc-bridge-odbc-driver , salesforce-odbc-driver , xml-odbc-driver , json-odbc-driver	44	July 28, 2026
SSIS Tutorial: How to use expressions inside API connection SSIS Tutorials ssis-api-src , ssis-powerpack	124	July 17, 2026
SQL Server Agent Fails to Recognize ZappySys Connection Managers After Deploying to SSISDB SSIS Tutorials ssis-powerpack	78	July 13, 2026
SSIS tutorial: How to check if your file is empty SSIS Tutorials ssis-validation-task , ssis-adv-file-system-task , ssis-excel-file-src , ssis-powerpack	83	July 8, 2026
How to Access ODBC DSN in Java Using ZappySys Data Gateway ODBC Tutorials odbc-powerpack , data-gateway-service , java	41	June 5, 2026
How to connect Tripletex to PowerBI ODBC Tutorials power-bi , odbc-powerpack , json-odbc-driver	25	May 14, 2026
ODBC Tutorial: How to Use Functions Inside the URL ODBC Tutorials rest-api , odbc-powerpack , date-format	35	May 14, 2026
SSIS tutorial: How to add more tasks (beyond the default Toolbox) SSIS Tutorials ssis-powerpack	93	March 26, 2026
ODBC tutorial: How to read and modify data in Salesforce with Excel ODBC Tutorials salesforce-odbc-driver , odbc-powerpack , excel	65	January 21, 2026
ODBC tutorial: How to connect to ChatGPT in Excel ODBC Tutorials odbc-powerpack , excel , json-odbc-driver , chatgpt , ai	81	January 22, 2026
SSIS tutorial: How to export SOAP web service data to Excel SSIS Tutorials ssis-xml-file-src , ssis-excel-file-dest , ssis-powerpack	71	December 11, 2025
ODBC tutorial: How to read Apache Derby data in ODBC ODBC Tutorials jdbc-bridge-odbc-driver , odbc-powerpack	36	December 24, 2025
SSIS tutorial: How to connect Slack with SSIS SSIS Tutorials ssis-rest-api-task , ssis-powerpack	62	December 31, 2025
Tutorial: How to choose correct Salesforce OAuth Authorize and Token URL Tutorials salesforce , ssis-salesforce-src , ssis-salesforce-dest , salesforce-odbc-driver	130	November 18, 2025
How to Cache OAuth Tokens in ODBC / SSIS PowerPack to Reuse Sessions SSIS Tutorials odbc-powerpack , ssis-powerpack , oauth	68	January 16, 2026
SSIS tutorial: How to insert only new rows in SQL Server SSIS Tutorials ssis-upsert-dest , ssis-json-file-src , ssis-powerpack , upsert	83	February 8, 2024
Deploying SSIS packages to SQL Server 2025 with ZappySys connectors SSIS Tutorials deployment , ssis-powerpack	177	January 8, 2026
How to access ODBC Data source in SQL Server ODBC Tutorials odbc , linked-server , sql-server , odbc-powerpack	78	December 26, 2025
SSIS tutorial: Use Wireshark to capture Low-Level Network Traffic SSIS Tutorials ssis-postgresql-src , ssis-postgresql-dest , postgresql , wireshark , tools	843	March 22, 2024