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