All Tags »
SSIS »
ODBC »
SP2 »
RetainSameConnection
Sorry, but there are no more tags available to filter with.
-
We have an AS400 source system and can only use ODBC connections to access it. We also need to set RetainSameConnection to true since we're initializing the AS400 connection with a number of temporary aliases that will be used by later Data Flows and Execute SQL Tasks.
Turns out that when using the ODBC driver in SSIS with Execute SQL & ...