Groups | Blog | Home
all groups > sql server dts > may 2005 >

sql server dts : DTS package error


Allan Mitchell
5/4/2005 12:00:00 AM
It is more than likely an issue with permissions

Have a read of this

http://support.microsoft.com/?kbid=269074

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


[quoted text, click to view]

Cynthia
5/4/2005 1:31:05 PM
created package through sql using the all tasks extract info selected a
mdb file on my server. then asked this to create a dts package and
scheduled it for once a week. when I run it manually I have no problem.
When it runs through the scheduler it cannot find the mdb file on the server.
AddThis Social Bookmark Button