SQL Server integration services environment setup

These are required steps;

1. SQL Server Integration Services

Install Integration Services

2. Create SSIS DB Catalog using SQL Server Management Studio

Create and Configure SSIS Catalog

3. Microsoft Access Database Engine 2016 Redistributable (ACE driver for Excel Files)

Install Microsoft Access Database Engine 2016 Redistributable

4. A domain account that has read/write/delete permission to file system.

This will be used as a proxy account. This is required because SSIS Packages will run from SQL Server Agent and the job will fail because of security context.

Add to favorites