CODEWITHSUNDEEP
sql-serverssis
Burco
Burco

Reputation: 95

SSIS - Save flat file on another server

is there any way I can save flat file into another server? SSIS package is doing SQL select from database and saving into file on same server (server A).

At this point everything is working (even when connected with SQL Job agent). Then I change directory where to save output.csv

Choose other server and new_output.csv (on server B). path looks \\serverb\test\new_output.csv. I change permissions to folder and file so server A can have access.

But when I run SSIS package I get warning: access denied. I dont get why. I added user and computer to permission.

Is there any other way how to make it? I will be really thankfull if anybody can give me any idea

PS: I try file system task..but mostly, there are tutorials to copy file into same server.

Upvotes: 0

Views: 1535

Answers (2)

Sanushi Salgado
Sanushi Salgado

Reputation: 1436

Try sharing the folder (Everyone) & provide the network path as the output directory. Folder sharing

Upvotes: 0

ɐlǝx
ɐlǝx

Reputation: 1394

The easiest way to try is to create the file on the server A before, and then copy it to the server B.

Upvotes: 1

Related Questions