Home Forums Data Warehousing Integration Services SSIS: use 2 different connections managers in one datasource RE: SSIS: use 2 different connections managers in one datasource
larskandersen
Ten Centuries
Points: 1232
More actions
July 9, 2013 at 6:37 am
#1630767
Workaround:
Fetch the LastUsedNumber in your control flow, store it in a variable, and either:
A) pass it into your data flow source as a parameter
B) Create the SQL statement as an expression with a second variable