The requested OLE DB provider Microsoft.Jet.OLEDB.4.0 is not registered

2023-06-15

Posted in:
SQL Server
SSIS
Visual Studio

Differences between your development workstation and a SQL Server host can make SSIS packages challenging. Here's how I overcame one of those obstacles.

[...Read More]

Documenting SSIS Packages

2019-09-25

Posted in:
Database Administration
Development
SQL Server
SSIS
SSMS
T-SQL
Visual Studio

SSIS packages are pretty easy to document if your deployments are old school. [...Read More]

Visual Studio: Create a Python Environment from SQL Server 2017 Machine Learning Services

2017-10-05

Posted in:
Python
SQL Server 2017
Visual Studio

How to configure Visual Studio to run Python, using the SQL Server 2017 Python interpreter. [...Read More]