Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 354
  • Last Modified:

DTS failure access problem

There is a problem in executing my dts package as it gives
"Error in opening data file access denied" after executing and double clicking the failed dts.

Message while executing the dts.And dts execution fails too.

This dts will trucate a table and take data from a csv file which is
located in a folder. And trasfer data to a sql database.

I have the access permissions of ms sql database and found that i have dbo full privilege.
But i doubt about folder permission. I have full permission except "special permission" for that
particular folder.

There is no logging enabled and i don't know where to see and rectify the error!

Please help me .. thanks!
0
jaisonshereen
Asked:
jaisonshereen
2 Solutions
 
srafi78Commented:
This error might be occurring because you are executing the package remotely and not locally on the server.
0
 
Mark WillsTopic AdvisorCommented:
srafi78 does make a good point - all those folders are from the perspective of the server and uses the credentials of the user running the job. It does sound like it cannot see the input file, and most likely a credentials or network path problem - things like mapped shared drives and suchlike also nee to be available to the user executing the package...

Does it fail when running interactively, by scheduled runs, or both ?

Have you checked SQL log in: Program Files\Microsoft SQL Server\Mssql\Log\Errorlog.  and sql server agent logs (can do both via EM)
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now