Optimized SSIS Connector Setting - Aster Client

Teradata Aster® Client Guide

Product
Aster Client
Release Number
7.00
Published
May 2017
Language
English (United States)
Last Update
2018-04-13
dita:mapPath
hki1475000360386.ditamap
dita:ditavalPath
Generic_no_ie_no_tempfilter.ditaval
dita:id
B700-2005
lifecycle
previous
Product Category
Software

This optimized SSIS Connector setting results in improved performance:

  • Execute Method:
    • Execute Package Utility
  • Aster Export Connection Manager:
    • KeepTempFile = False
  • Aster Loader Connection Manager:
    • KeepTempFile = False
    • ErrorLogging=False
  • Aster Export Source:
    • CSVFileReadBufferSize = 40960
  • Aster Loader Destination:
    • CLIExecuteModer = AtEndOfRowset
    • ErrorCheck = Aster Check
  • Control Flow Properties:
    • EngineThreads = 10
    • DefaultBufferSize = 104857600
    • DefaultBufferMaxRows = 50000
    • RunOptimizedMode = true
  • Package Properties:
    • MaxConcurrentExecutables = -1