Advanced ETL Processor can export database data to delimited text files from a package by using the SQL To Text action. This tutorial shows the setup pattern for exporting tables from a database, including the connection, SQL source, file output, and logging checks.
What You Will Learn
- Create a package step that exports SQL data to a text file.
- Select the database connection used by the export action.
- Choose whether the action uses embedded SQL or a saved SQL script.
- Check the action execution log after the export runs.
Before You Start
Use a test database and write the output to a local or UNC path you can delete afterwards. Avoid mapped drives for scheduled or unattended package runs.
SQL To Text Action Docs
The SQL To Text Dynamic Action documentation explains how a package exports SQL query or table output into delimited text files such as CSV or TSV.
Use the Parameters tab to control the SQL source, output file, delimiter, headers, encoding, and variable replacement. The UseEmbeddedSQL setting decides whether the action uses embedded SQL or a saved SQL script.
For SQL setup, review Selecting Script, Editing Script, and Selecting Connection.
If the package needs runtime values, check the Variables tab. After the export runs, use the Execution log tab to confirm what happened.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.