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	21	November 27, 2025
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	20	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	21	July 31, 2026
SSIS tutorial: How to filter files in the ZappySys SFTP Task SSIS Tutorials ssis-powerpack , ssis-sftp-task	18	July 31, 2026
SSIS tutorial: How to find the correct property name for SSIS expressions SSIS Tutorials expressions , ssis-powerpack , ssis-sftp-task	15	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	33	July 28, 2026
SSIS Tutorial: How to use expressions inside API connection SSIS Tutorials ssis-api-src , ssis-powerpack	110	July 17, 2026
SQL Server Agent Fails to Recognize ZappySys Connection Managers After Deploying to SSISDB SSIS Tutorials ssis-powerpack	67	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	70	July 8, 2026
How to Access ODBC DSN in Java Using ZappySys Data Gateway ODBC Tutorials odbc-powerpack , data-gateway-service , java	27	June 5, 2026
How to connect Tripletex to PowerBI ODBC Tutorials power-bi , odbc-powerpack , json-odbc-driver	19	May 14, 2026
ODBC Tutorial: How to Use Functions Inside the URL ODBC Tutorials rest-api , odbc-powerpack , date-format	29	May 14, 2026
SSIS tutorial: How to add more tasks (beyond the default Toolbox) SSIS Tutorials ssis-powerpack	87	March 26, 2026
ODBC tutorial: How to read and modify data in Salesforce with Excel ODBC Tutorials salesforce-odbc-driver , odbc-powerpack , excel	61	January 21, 2026
ODBC tutorial: How to connect to ChatGPT in Excel ODBC Tutorials odbc-powerpack , excel , json-odbc-driver , chatgpt , ai	69	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	64	December 11, 2025
ODBC tutorial: How to read Apache Derby data in ODBC ODBC Tutorials jdbc-bridge-odbc-driver , odbc-powerpack	32	December 24, 2025
SSIS tutorial: How to connect Slack with SSIS SSIS Tutorials ssis-rest-api-task , ssis-powerpack	54	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	110	November 18, 2025
How to Cache OAuth Tokens in ODBC / SSIS PowerPack to Reuse Sessions SSIS Tutorials odbc-powerpack , ssis-powerpack , oauth	63	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	76	February 8, 2024
Deploying SSIS packages to SQL Server 2025 with ZappySys connectors SSIS Tutorials deployment , ssis-powerpack	162	January 8, 2026
How to access ODBC Data source in SQL Server ODBC Tutorials odbc , linked-server , sql-server , odbc-powerpack	71	December 26, 2025
SSIS tutorial: Use Wireshark to capture Low-Level Network Traffic SSIS Tutorials ssis-postgresql-src , ssis-postgresql-dest , postgresql , wireshark , tools	835	March 22, 2024
ODBC tutorial: How to extract data from API response JSON Array in ODBC ODBC Tutorials json-odbc-driver , odbc-powerpack	439	March 27, 2024
ODBC tutorial: How to connect to an Azure CSV file with ODBC ODBC Tutorials	359	May 16, 2024
SSIS tutorial: How to send rich HTML emails with CSS SSIS Tutorials ssis-send-html-email-task , ssis-powerpack	60	November 20, 2025
SSIS tutorial: How to split a large CSV into multiple files SSIS Tutorials ssis-csv-file-dest , ssis-json-file-src , ssis-powerpack	76	October 30, 2025
SSIS tutorial: How to call TD Ameritrade API in SSIS SSIS Tutorials ssis-powerpack	311	March 7, 2024
Tutorial: Export Data to Parquet Files in SSIS using the ODBC Parquet (DuckDB) Connector Tutorials jdbc-bridge-odbc-driver , odbc-powerpack , ssis-powerpack	104	December 22, 2025