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

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 easier to create updated reports using data from an SQL Server. This question of scheduling dts packages often shows up in SQL forums.


Read the full article here: Using Data Transformation Services: Package Execution Using SQL Server Agent, Introduction

For more discussion go here: Blog Article Discussion