Mincong Huang Blog
Run SSIS package using 32-bit drivers
Today, when I used an OLD DB source to connect a MS Access database, I met the following message error during debug :
The message suggests me to use 32-bit driver because the driver of 64-bit is not available. This is caused by the MS Access provider.
In order to resolve this problem, I configured the SSIS pakcages to run by referencing the 32-bit dlls :
Release unused space using Shrink
Database's size can be optimized using Shrink command. It helps to release unused space. There're 2 ways to do it: via GUI or via T-SQL.