Spit File Dynamic Action

About

The Spit File Action divides a text file into smaller files containing a fixed number of rows.

Metadata tab

Split File Action - Metadata tab
 

  1. The Write Variables option ensures that the “Package Action” logs the variable values into the “Action vars before log file” before the action is executed and logs the updated variable values into the “Action vars after log file” after the action completes.
  2. This option is typically used for debugging and is not recommended in a production environment.
  3. It can be globally disabled through the options dialog .

Parameters tab

Split File Action - Parameters tab

N Value Parameter

The meaning of N Value parameter depends on Which File Parameter

  1. When Which File Parameter is equal to “Files Not Older Than N Days” N Value is Days
  2. When Which File Parameter is equal to “Files Older Than N Days” N Value is Days
  3. When Which File Parameter is equal to “First N Found Files” N Value file number
  4. When Which File Parameter is equal to “Bigger Than N Bytes” N Value is byte

Target Files Parameter

There are a number of variables which can be used to calculate target file name.

Variable Description
#CurrentSourceFileName# This variable holds source file name without path or expansion
#CurrentSourceFileExt# This variable holds Current Source File Extension
#SplitFileNo# This variable holds sequential Split File Number
#CurrentSourceFileNumber# This variable holds sequential Source File Number
#CurrentSourceFile# This variable holds Source File Name including path and extensionThis variable holds Source File Name including path and extensionThis variable holds Source File Name including path and extensionThis variable holds Source File Name including path and extension

Example

C:\Support\#CurrentSourceFileName#_#SplitFileNo##CurrentSourceFileExt#

Variables tab

The Variables tab defines which variables are updated during the execution of the action.

Split File Action - Variables tab

Execution log tab

The Execution Log tab is populated after the action has been executed. Double-click a row to view the detailed execution log.

Split File Action - Execution log tab
  1. Change Encoding Action
  2. Compare Files Action
  3. Check File Action
  4. Check File Date Action
  5. File Meta Data Action
  6. Split File Action
  7. Copy File Action
  8. Split File Action
  9. Move File Action
  10. Rename File Action
  11. Delete File Action
  12. Keep File Action
  13. Merge File Action
  14. Change File Attributes Action
  15. Files List Action
  16. Replace String Action
  17. Open File Action
  18. Encrypt Action
  19. Decrypt Action

Video Tutorial


For more technologies supported by our ETL Software see Advanced ETL Processor Versions

Confused? Ask question on our ETL Forum

Posted on September 30, 2026 • 3 min read • 513 words
www.etl-tools.com About Support Pricing Cookies Policy Term Of Use Privacy Policy License