Home Forums Data Warehousing Data Transformation Services (DTS) Dts-import fails -Exception access violation RE: Dts-import fails -Exception access violation
Japie Botma
SSCrazy
Points: 2940
More actions
August 26, 2004 at 3:32 am
#520662
If you are running the DTS package as a job, your SQL agent needs access to the operating system file. That means your sql agent must be started with windows authentication.
5ilverFoxConsulting DBA / DeveloperSouth Africa