Yovcho IvanovMar 2, 20217 minSetting up your cost-effective Azure Database Environment (2)Chapter 2 Resources This chapter aims to look at the resources that will be needed to deliver the database solution. Sub-articles will be...
Yovcho IvanovSep 28, 20194 minExport and Archive SQL Datasets from the Reporting Server1. Problem The problem that our business is facing now is that we lack documentation of our datasets for the reports. Since we’re working...
Yovcho IvanovSep 12, 20192 minSSIS - Switching from 64-bit to 32-bitSwitch package from 64bit to 32bit Case My Data Flow Task with an Excel connection doesn't run. It throws the following error: Just...
Yovcho IvanovSep 12, 20191 minSSIS - Manual TestsSSIS Testing Plan: 1. Verify all tables have been imported. 2. Verify all rows in each table have been imported. 3. Verify all the...
Yovcho IvanovSep 8, 20195 minSSIS - Performing UpsertsIt is a common scenario, when we need a script, package or something else to perform insert and update in a table simultaneously....