Hi All,

I'm trying to import data from teradata to Sql server using Microsoft SSIS connector by Attunity. The rsultset is about 220M records. Below scenarios are happening:
1. the Attunity data source property MaxSession = 1 and SSIS is run using the SQL Server agent job the job fails after importing about 210M records with the error message "Unexpected Termination". No more error message.
2.the Attunity data source property MaxSession = 8 and SSIS is run using the SQL Server agent job the job succeeds
3.the Attunity data source property MaxSession = 1 and SSIS is run locally through visual studio and the SSIS package run succeeds.

Is there any chance anybody can explain what exactly MaxSession setting does and why these different behaviours.

below are our system configurations:

SQL Server 2016 Enterprise Edition SP1
Microsoft SSIS connector by Attunity v4.0
Teradata 15.10.0503 15.10.05.03B
ODBC 14.10.00.03
Visual Studio 2015

Thanks in advance,
Nima