Use tSetGlobalVar to Record a Count

If you want to use one or more global variables set by an input flow like a tOracleInput throughout your Talend job, consider using tSetGlobalVar.  Convert the flow from the input component into an iterate and map a field to a key in the tSetGlobalVar component.

Talend to MS SQL with Windows Authentication

To connect a Talend integration job to MS SQL Server using Windows Authentication, use the tOleDbInput component rather than the tMSSqlInput.  You'll need to put some DLLs on the system running Talend.