In order to copy all files in certain folder to another folder (with the same
file name) I have placed a File System Task inside the foreeach Loop
container.
However, I'm not sure on how to set the variables ie. the property of the
File System Task. Should I use variables and expressions?

Please advise.

Thanks.

On Jan 11, 4:04*pm, rkbnair <rkbn... (AT) community (DOT) nospam> wrote:
If you haven't already created a variable for the archive/new location
you can do so from within the File System task

1. Set IsDestinationPathVariable to "True"
2. click the DestinationVariable drop down and select new variable
giving t a name like varArchiveLocation setting the value to the
archive/new location
3. Set Operation to "Move File"
4. If you have the source set as a variabe the be sure to set the
IsSourcePathVariable to "True" otherwise leave as "False"
5. Click the drop down in the SourceConnection and select your
connection object you created in the connection manager

I think I have all the steps you need but each one is c learly
identified in the File System Task.

HTH

NC3

On Jan 11, 4:04*pm, rkbnair <rkbn... (AT) community (DOT) nospam> wrote:
If you haven't already created a variable for the archive/new location
you can do so from within the File System task

1. Set IsDestinationPathVariable to "True"
2. click the DestinationVariable drop down and select new variable
giving t a name like varArchiveLocation setting the value to the
archive/new location
3. Set Operation to "Move File"
4. If you have the source set as a variabe the be sure to set the
IsSourcePathVariable to "True" otherwise leave as "False"
5. Click the drop down in the SourceConnection and select your
connection object you created in the connection manager

I think I have all the steps you need but each one is c learly
identified in the File System Task.

HTH

NC3

On Jan 11, 4:04*pm, rkbnair <rkbn... (AT) community (DOT) nospam> wrote:
If you haven't already created a variable for the archive/new location
you can do so from within the File System task

1. Set IsDestinationPathVariable to "True"
2. click the DestinationVariable drop down and select new variable
giving t a name like varArchiveLocation setting the value to the
archive/new location
3. Set Operation to "Move File"
4. If you have the source set as a variabe the be sure to set the
IsSourcePathVariable to "True" otherwise leave as "False"
5. Click the drop down in the SourceConnection and select your
connection object you created in the connection manager

I think I have all the steps you need but each one is c learly
identified in the File System Task.

HTH

NC3

On Jan 11, 4:04*pm, rkbnair <rkbn... (AT) community (DOT) nospam> wrote:
If you haven't already created a variable for the archive/new location
you can do so from within the File System task

1. Set IsDestinationPathVariable to "True"
2. click the DestinationVariable drop down and select new variable
giving t a name like varArchiveLocation setting the value to the
archive/new location
3. Set Operation to "Move File"
4. If you have the source set as a variabe the be sure to set the
IsSourcePathVariable to "True" otherwise leave as "False"
5. Click the drop down in the SourceConnection and select your
connection object you created in the connection manager

I think I have all the steps you need but each one is c learly
identified in the File System Task.

HTH

NC3

On Jan 11, 4:04*pm, rkbnair <rkbn... (AT) community (DOT) nospam> wrote:
If you haven't already created a variable for the archive/new location
you can do so from within the File System task

1. Set IsDestinationPathVariable to "True"
2. click the DestinationVariable drop down and select new variable
giving t a name like varArchiveLocation setting the value to the
archive/new location
3. Set Operation to "Move File"
4. If you have the source set as a variabe the be sure to set the
IsSourcePathVariable to "True" otherwise leave as "False"
5. Click the drop down in the SourceConnection and select your
connection object you created in the connection manager

I think I have all the steps you need but each one is c learly
identified in the File System Task.

HTH

NC3

On Jan 11, 4:04*pm, rkbnair <rkbn... (AT) community (DOT) nospam> wrote:
If you haven't already created a variable for the archive/new location
you can do so from within the File System task

1. Set IsDestinationPathVariable to "True"
2. click the DestinationVariable drop down and select new variable
giving t a name like varArchiveLocation setting the value to the
archive/new location
3. Set Operation to "Move File"
4. If you have the source set as a variabe the be sure to set the
IsSourcePathVariable to "True" otherwise leave as "False"
5. Click the drop down in the SourceConnection and select your
connection object you created in the connection manager

I think I have all the steps you need but each one is c learly
identified in the File System Task.

HTH

NC3

On Jan 11, 4:04*pm, rkbnair <rkbn... (AT) community (DOT) nospam> wrote:
If you haven't already created a variable for the archive/new location
you can do so from within the File System task

1. Set IsDestinationPathVariable to "True"
2. click the DestinationVariable drop down and select new variable
giving t a name like varArchiveLocation setting the value to the
archive/new location
3. Set Operation to "Move File"
4. If you have the source set as a variabe the be sure to set the
IsSourcePathVariable to "True" otherwise leave as "False"
5. Click the drop down in the SourceConnection and select your
connection object you created in the connection manager

I think I have all the steps you need but each one is c learly
identified in the File System Task.

HTH

NC3

On Jan 11, 4:04*pm, rkbnair <rkbn... (AT) community (DOT) nospam> wrote:
If you haven't already created a variable for the archive/new location
you can do so from within the File System task

1. Set IsDestinationPathVariable to "True"
2. click the DestinationVariable drop down and select new variable
giving t a name like varArchiveLocation setting the value to the
archive/new location
3. Set Operation to "Move File"
4. If you have the source set as a variabe the be sure to set the
IsSourcePathVariable to "True" otherwise leave as "False"
5. Click the drop down in the SourceConnection and select your
connection object you created in the connection manager

I think I have all the steps you need but each one is c learly
identified in the File System Task.

HTH

NC3

I did all that already. But it still does not copy. Sometimes it copies just
one file and stops.

"NC3" wrote: