Avatar of cipriano555
cipriano555

asked on 

Permissions problem writing to a remote server from an SSIS package

I have developed a front end application for a SQL Server 2012 database using MS Access.  Using this application can cause data to be read and  written to the database, and it can also cause flat files to be written out.  I am able to run the parts that read and write to the database.  The application at one point causes an SSIS package to run, which writes to an external file.  The external file is on a different server than the database.  I get an "access is denied" error even though I have full read/write access privileges to the file.  We use Windows authentication for everything.  What do I need to do to get the file read operation to succeed without the permissions problem

So there is the desktop A, which talks to the SQL Server database on Server B, successfully reading and writing to the database.  The application attempts to write a file to Server C where there is a permissions fail.  User has full read write to the location where the file is supposed to be written.
SSIS-PermissionsProblem.JPG
Microsoft SQL Server 2008Microsoft SQL ServerMicrosoft AccessSSIS

Avatar of undefined
Last Comment
Vitor Montalvão
ASKER CERTIFIED SOLUTION
Avatar of Vikas Garg
Vikas Garg
Flag of India image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft Access
Microsoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo