Hello Everybody,
I do have question abt archive and deleting file from remote server using
SSIS.
I have one database server (payrollproduction) where I pull file from
another server (HRproduction). After pulling xml files to payrollproduction
from HRproduction, I want to archive those files into HRproduction(source)
in archive folder and then delete from original folder. I will run that SSIS
from payrollproduction server.
How can I do it ? Please let me know

Set up a For Each loop that processes the XML file(s). Inside the loop have a
File System task that moves the processed file from one location to another.
Set the precedence constraint to only move the file if the data flow is
successful.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"mvp" wrote:

Set up a For Each loop that processes the XML file(s). Inside the loop have a
File System task that moves the processed file from one location to another.
Set the precedence constraint to only move the file if the data flow is
successful.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"mvp" wrote:

Set up a For Each loop that processes the XML file(s). Inside the loop have a
File System task that moves the processed file from one location to another.
Set the precedence constraint to only move the file if the data flow is
successful.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"mvp" wrote:

Set up a For Each loop that processes the XML file(s). Inside the loop have a
File System task that moves the processed file from one location to another.
Set the precedence constraint to only move the file if the data flow is
successful.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"mvp" wrote:

Set up a For Each loop that processes the XML file(s). Inside the loop have a
File System task that moves the processed file from one location to another.
Set the precedence constraint to only move the file if the data flow is
successful.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"mvp" wrote:

Set up a For Each loop that processes the XML file(s). Inside the loop have a
File System task that moves the processed file from one location to another.
Set the precedence constraint to only move the file if the data flow is
successful.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"mvp" wrote:

Set up a For Each loop that processes the XML file(s). Inside the loop have a
File System task that moves the processed file from one location to another.
Set the precedence constraint to only move the file if the data flow is
successful.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"mvp" wrote:

Set up a For Each loop that processes the XML file(s). Inside the loop have a
File System task that moves the processed file from one location to another.
Set the precedence constraint to only move the file if the data flow is
successful.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"mvp" wrote:

Yes, But I want to move file in remote server (not in the server where the
job will run). Is is possible doing by File System Task.

Thanks

"Todd C" wrote: