Chapter 2 Resources This chapter aims to look at the resources that will be needed to deliver the database solution. Sub-articles will be...

1. Problem The problem that our business is facing now is that we lack documentation of our datasets for the reports. Since we’re working...

Switch package from 64bit to 32bit Case My Data Flow Task with an Excel connection doesn't run. It throws the following error: Just...

SSIS Testing Plan: 1. Verify all tables have been imported. 2. Verify all rows in each table have been imported. 3. Verify all the...

It is a common scenario, when we need a script, package or something else to perform insert and update in a table simultaneously....