I would like to call this as how efficiently you can obtain counting rows in SSIS package. Usual thought would come is @@rowcount or COUNT_BIG functions, but this is not that efficient way to obtain the results. SSIS provides the snippet within its components such as using Row Count component, for this you have to create a variable of integer ...

High-speed heterogeneous integration is a challenge for many corporate IT departments today. Most modern IT groups are having to deal with an incredible amount of disparate systems across the organization, coupled with an ever-growing data set. To address these challenges, many IT pros are looking at bringing in high-speed data interconnects to ...