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 :
[Connection manager “\DVDSIB46\d$\DVI_Datas\Source\Dise\EXTRACTION DONNEES
MOBILITE.accdb”] Error: The requested OLE DB provider Microsoft.ACE.OLEDB.12.0
is not registered. If the 64-bit driver is not installed, run the pa...
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.
187 post articles, 24 pages.