I have a Job that needs to read 12 different tables from the same MSSQL database.
Is it better to use 1 tMSSqlConnection and set all 12 tMSSqlInput to "Use Existing Connection"? Or is it better to keep the database parameters local to each tMSSqlInput?
it depend from You Job logic
generally more easy define single connection and close it after finish Job
with single connection You are as well can enable auto commit or use manual/rollback commit when it needed
but at the same time - all Your tables must be in same database(schema)
without single connection:
You can manage commit windows (commit every XXX rows)
You can have separate Database(schema) for each Input component
From information point of view:
if You use context variables instead of hardcoded details - change any information will be same, in single place only
