Using Data Transformation Services: Package Execution Using SQL Server Agent, Introduction

(Jayaram Krishnaswamy) The scenario is one of creating a DTS package that populates a table in an MS Access database from an SQL Server database on a schedule. The scheduling is to be carried out by creating an SQL Job. MS Access is often used for creating reports, and this scheduling makes it e

Read More - Register for Free Membership