Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access denied message after a newer version of DTS package was created

Status
Not open for further replies.

mmuzaffar

MIS
May 1, 2006
17
US
I need help as yesterday i created a new dts package which is a copy of old DTS package because it was under some other users name so i saved it under mine
there is was job associated with this DTS package and now it is failing and giving following error messeges

DTSRun: Loading...

DTSRun: Executing...

DTSRun OnStart: Create Table [Page4].[dbo].[NEW] Step

DTSRun OnFinish: Create Table [Page4].[dbo].[NEW] Step

DTSRun OnStart: Copy Data from newagin to [Page4].[dbo].[NEW] Step

DTSRun OnError: Copy Data from newagin to [Page4].[dbo].[NEW] Step, Error = -2147467259 (80004005)

Error string: Error opening datafile: Access is denied.



Error source: Microsoft Data Transformation Services Flat File Rowset Provider

Help file: DTSFFile.hlp

Help context: 0



Error Detail Records:



Error: 5 (5); Provider Error: 5 (5)

Error string: Error opening datafile: Access is denied.



Error source: Microsoft Data Transformation Services Flat File Rowset Provider

Help file: DTSFFile.hlp

Help context: 0


please advice me what need to be done why i am getting this access denied message as i have the sa rights on this machine.
thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top