How to Run a DTS Package as a Scheduled Job

A problem that you might frequently encounter with a Data Transformation Services (DTS) package is that the DTS package runs error-free from the SQL Server Enterprise Manager, but the DTS package fails when it is scheduled to run as a job. This article explains the security issues involved in running DTS packages.

read more | digg story

Advertisements

%d bloggers like this: