To copy files from a folder to another folder

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

"NC3" wrote:

> On Jan 11, 4:04 pm, rkbnair wrote:
> > 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.
>
> 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
>
 >> Stay informed about: To copy files from a folder to another folder 

On Jan 11, 5:38 pm, rkbnair wrote:
> I did all that already. But it still does not copy. Sometimes it copies just
> one file and stops.
>
>
>
> "NC3" wrote:
> > On Jan 11, 4:04 pm, rkbnair wrote:
> > > 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.
>
> > 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- Hide quoted text -
>
> - Show quoted text -

I would look at the ForEachLoop enumerator configurations.

Do the files have the same extension or different extensions. If the
same set the File config to *.extensionname
If the extension are different then set File Config to *.* so it can
enumerate each file type.
 >> Stay informed about: To copy files from a folder to another folder 

My file specification is *.*. There are only few files in the folder and the
file names are different.


"NC3" wrote:

> On Jan 11, 5:38 pm, rkbnair wrote:
> > I did all that already. But it still does not copy. Sometimes it copies just
> > one file and stops.
> >
> >
> >
> > "NC3" wrote:
> > > On Jan 11, 4:04 pm, rkbnair wrote:
> > > > 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.
> >
> > > 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- Hide quoted text -
> >
> > - Show quoted text -
>
> I would look at the ForEachLoop enumerator configurations.
>
> Do the files have the same extension or different extensions. If the
> same set the File config to *.extensionname
> If the extension are different then set File Config to *.* so it can
> enumerate each file type.
>
 >> Stay informed about: To copy files from a folder to another folder 

Hello,

I tested on my side.

You need to specify a variable in the ForEachloop. For example User::vFile

Then, in the File system task, in the Source destination, you need to
create a new file connection. In this file connnection, you need to use the
exist file. Then, open the properties of the file connection, remove the
exist connection string and then specify in the Expression that the
Connection String to be the User::vFile.

Then, you may copy the file.

You could refer the sample ExecuteSQLStatementsInLoop in the SQL Server
2005.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
 >> Stay informed about: To copy files from a folder to another folder 

Hi Lu,

Thanks for the reply.

For your information:
Source file path="'V:\1aaa\Disk1"
Target file Path="'V:\1aaa\Disk2"

I made the changes that you have suggested. Still getting the following error:

SSIS package "Package.dtsx" starting.
Error: 0xC002F304 at File System Task, File System Task: An error occurred
with the following error message: "The process cannot access the file
'V:\1aaa\Disk1\data1.cab' because it is being used by another process.".
Warning: 0x80019002 at File System Task: The Execution method succeeded, but
the number of errors raised (1) reached the maximum allowed (1); resulting in
failure. This occurs when the number of errors reaches the number specified
in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
Task failed: File System Task
Error: 0xC002F304 at File System Task, File System Task: An error occurred
with the following error message: "The process cannot access the file
'V:\1aaa\Disk1\data1.hdr' because it is being used by another process.".
Warning: 0x80019002 at File System Task: The Execution method succeeded, but
the number of errors raised (1) reached the maximum allowed (1); resulting in
failure. This occurs when the number of errors reaches the number specified
in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
Task failed: File System Task
Error: 0xC002F304 at File System Task, File System Task: An error occurred
with the following error message: "The process cannot access the file
'V:\1aaa\Disk1\data2.cab' because it is being used by another process.".
Warning: 0x80019002 at File System Task: The Execution method succeeded, but
the number of errors raised (1) reached the maximum allowed (1); resulting in
failure. This occurs when the number of errors reaches the number specified
in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
Task failed: File System Task
Error: 0xC002F304 at File System Task, File System Task: An error occurred
with the following error message: "The process cannot access the file
'V:\1aaa\Disk1\ikernel.ex_' because it is being used by another process.".
Warning: 0x80019002 at File System Task: The Execution method succeeded, but
the number of errors raised (1) reached the maximum allowed (1); resulting in
failure. This occurs when the number of errors reaches the number specified
in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
Task failed: File System Task
Error: 0xC002F304 at File System Task, File System Task: An error occurred
with the following error message: "The process cannot access the file
'V:\1aaa\Disk1\layout.bin' because it is being used by another process.".
Warning: 0x80019002 at File System Task: The Execution method succeeded, but
the number of errors raised (1) reached the maximum allowed (1); resulting in
failure. This occurs when the number of errors reaches the number specified
in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
Task failed: File System Task
Error: 0xC002F304 at File System Task, File System Task: An error occurred
with the following error message: "The process cannot access the file
'V:\1aaa\Disk1\setup.bmp' because it is being used by another process.".
Warning: 0x80019002 at File System Task: The Execution method succeeded, but
the number of errors raised (1) reached the maximum allowed (1); resulting in
failure. This occurs when the number of errors reaches the number specified
in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
Task failed: File System Task
Error: 0xC002F304 at File System Task, File System Task: An error occurred
with the following error message: "The process cannot access the file
'V:\1aaa\Disk1\Setup.exe' because it is being used by another process.".
Warning: 0x80019002 at File System Task: The Execution method succeeded, but
the number of errors raised (1) reached the maximum allowed (1); resulting in
failure. This occurs when the number of errors reaches the number specified
in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
Task failed: File System Task
Error: 0xC002F304 at File System Task, File System Task: An error occurred
with the following error message: "The process cannot access the file
'V:\1aaa\Disk1\Setup.ini' because it is being used by another process.".
Warning: 0x80019002 at File System Task: The Execution method succeeded, but
the number of errors raised (1) reached the maximum allowed (1); resulting in
failure. This occurs when the number of errors reaches the number specified
in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
Task failed: File System Task
Error: 0xC002F304 at File System Task, File System Task: An error occurred
with the following error message: "The process cannot access the file
'V:\1aaa\Disk1\Setup.inx' because it is being used by another process.".
Warning: 0x80019002 at File System Task: The Execution method succeeded, but
the number of errors raised (1) reached the maximum allowed (1); resulting in
failure. This occurs when the number of errors reaches the number specified
in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
Task failed: File System Task
SSIS package "Package.dtsx" finished: Success.
The program '[3272] Package.dtsx: DTS' has exited with code 0 (0x0).
 >> Stay informed about: To copy files from a folder to another folder 

Hello,

Did you have any other process is running to access the file?


Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
 >> Stay informed about: To copy files from a folder to another folder 

No. There are no other processes running.

--
test


"Wei Lu [MSFT]" wrote:

> Hello,
>
> Did you have any other process is running to access the file?
>
>
> Sincerely,
>
> Wei Lu
> Microsoft Online Community Support
>
> ==================================================
>
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
>
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
 >> Stay informed about: To copy files from a folder to another folder 

Hello,

Could you send me an email so that I can provide the sample I created to
you?

Please remove the ONLINE in my display email to reach me.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
 >> Stay informed about: To copy files from a folder to another folder 

Lu,

I had sent email to you couple of times already.

Thanks.
--
test


"Wei Lu [MSFT]" wrote:

> Hello,
>
> Could you send me an email so that I can provide the sample I created to
> you?
>
> Please remove the ONLINE in my display email to reach me.
>
> Sincerely,
>
> Wei Lu
> Microsoft Online Community Support
>
> ==================================================
>
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
>
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
 >> Stay informed about: To copy files from a folder to another folder 

Hi, I know how to copy files using file system task.
I have lots of text files in one folder, I would like to copy everything except file names starts with "M".
please reply me.

Thanks




weil wrote:

Hello,Did you have any other process is running to access the file?
16-Jan-08

Hello,

Did you have any other process is running to access the file?


Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Previous Posts In This Thread:

On Friday, January 11, 2008 4:04 PM
rkbnai wrote:

To copy files from a folder to another folder
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 Friday, January 11, 2008 5:38 PM
rkbnai wrote:

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

"NC3" wrote:

On Saturday, January 12, 2008 7:28 AM
NC3 wrote:

Re: To copy files from a folder to another folder
On Jan 11, 4:04=A0pm, rkbnair wrote:
ame

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 Saturday, January 12, 2008 7:28 AM
NC3 wrote:

Re: To copy files from a folder to another folder
On Jan 11, 5:38=A0pm, rkbnair wrote:
st
he same
the

I would look at the ForEachLoop enumerator configurations.

Do the files have the same extension or different extensions. If the
same set the File config to *.extensionname
If the extension are different then set File Config to *.* so it can
enumerate each file type.

On Monday, January 14, 2008 2:25 PM
rkbnai wrote:

My file specification is *.*.
My file specification is *.*. There are only few files in the folder and the
file names are different.


"NC3" wrote:

On Monday, January 14, 2008 11:00 PM
weil wrote:

Hello,I tested on my side. You need to specify a variable in the ForEachloop.
Hello,

I tested on my side.

You need to specify a variable in the ForEachloop. For example User::vFile

Then, in the File system task, in the Source destination, you need to
create a new file connection. In this file connnection, you need to use the
exist file. Then, open the properties of the file connection, remove the
exist connection string and then specify in the Expression that the
Connection String to be the User::vFile.

Then, you may copy the file.

You could refer the sample ExecuteSQLStatementsInLoop in the SQL Server
2005.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

On Tuesday, January 15, 2008 5:36 PM
rkbnai wrote:

Hi Lu,Thanks for the reply.
Hi Lu,

Thanks for the reply.

For your information:
Source file path="'V:\1aaa\Disk1"
Target file Path="'V:\1aaa\Disk2"

I made the changes that you have suggested. Still getting the following error:

SSIS package "Package.dtsx" starting.
Error: 0xC002F304 at File System Task, File System Task: An error occurred
with the following error message: "The process cannot access the file
'V:\1aaa\Disk1\data1.cab' because it is being used by another process.".
Warning: 0x80019002 at File System Task: The Execution method succeeded, but
the number of errors raised (1) reached the maximum allowed (1); resulting in
failure. This occurs when the number of errors reaches the number specified
in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
Task failed: File System Task
Error: 0xC002F304 at File System Task, File System Task: An error occurred
with the following error message: "The process cannot access the file
'V:\1aaa\Disk1\data1.hdr' because it is being used by another process.".
Warning: 0x80019002 at File System Task: The Execution method succeeded, but
the number of errors raised (1) reached the maximum allowed (1); resulting in
failure. This occurs when the number of errors reaches the number specified
in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
Task failed: File System Task
Error: 0xC002F304 at File System Task, File System Task: An error occurred
with the following error message: "The process cannot access the file
'V:\1aaa\Disk1\data2.cab' because it is being used by another process.".
Warning: 0x80019002 at File System Task: The Execution method succeeded, but
the number of errors raised (1) reached the maximum allowed (1); resulting in
failure. This occurs when the number of errors reaches the number specified
in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
Task failed: File System Task
Error: 0xC002F304 at File System Task, File System Task: An error occurred
with the following error message: "The process cannot access the file
'V:\1aaa\Disk1\ikernel.ex_' because it is being used by another process.".
Warning: 0x80019002 at File System Task: The Execution method succeeded, but
the number of errors raised (1) reached the maximum allowed (1); resulting in
failure. This occurs when the number of errors reaches the number specified
in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
Task failed: File System Task
Error: 0xC002F304 at File System Task, File System Task: An error occurred
with the following error message: "The process cannot access the file
'V:\1aaa\Disk1\layout.bin' because it is being used by another process.".
Warning: 0x80019002 at File System Task: The Execution method succeeded, but
the number of errors raised (1) reached the maximum allowed (1); resulting in
failure. This occurs when the number of errors reaches the number specified
in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
Task failed: File System Task
Error: 0xC002F304 at File System Task, File System Task: An error occurred
with the following error message: "The process cannot access the file
'V:\1aaa\Disk1\setup.bmp' because it is being used by another process.".
Warning: 0x80019002 at File System Task: The Execution method succeeded, but
the number of errors raised (1) reached the maximum allowed (1); resulting in
failure. This occurs when the number of errors reaches the number specified
in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
Task failed: File System Task
Error: 0xC002F304 at File System Task, File System Task: An error occurred
with the following error message: "The process cannot access the file
'V:\1aaa\Disk1\Setup.exe' because it is being used by another process.".
Warning: 0x80019002 at File System Task: The Execution method succeeded, but
the number of errors raised (1) reached the maximum allowed (1); resulting in
failure. This occurs when the number of errors reaches the number specified
in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
Task failed: File System Task
Error: 0xC002F304 at File System Task, File System Task: An error occurred
with the following error message: "The process cannot access the file
'V:\1aaa\Disk1\Setup.ini' because it is being used by another process.".
Warning: 0x80019002 at File System Task: The Execution method succeeded, but
the number of errors raised (1) reached the maximum allowed (1); resulting in
failure. This occurs when the number of errors reaches the number specified
in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
Task failed: File System Task
Error: 0xC002F304 at File System Task, File System Task: An error occurred
with the following error message: "The process cannot access the file
'V:\1aaa\Disk1\Setup.inx' because it is being used by another process.".
Warning: 0x80019002 at File System Task: The Execution method succeeded, but
the number of errors raised (1) reached the maximum allowed (1); resulting in
failure. This occurs when the number of errors reaches the number specified
in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
Task failed: File System Task
SSIS package "Package.dtsx" finished: Success.
The program '[3272] Package.dtsx: DTS' has exited with code 0 (0x0).

On Wednesday, January 16, 2008 2:16 AM
weil wrote:

Hello,Did you have any other process is running to access the file?
Hello,

Did you have any other process is running to access the file?


Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

On Wednesday, January 16, 2008 9:32 AM
rkbnai wrote:

Re: To copy files from a folder to another folder
No. There are no other processes running.

--
test


"Wei Lu [MSFT]" wrote:

On Thursday, January 17, 2008 1:49 AM
weil wrote:

Hello,Could you send me an email so that I can provide the sample I created to
Hello,

Could you send me an email so that I can provide the sample I created to
you?

Please remove the ONLINE in my display email to reach me.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

On Tuesday, January 22, 2008 8:37 PM
rkbnai wrote:

Lu,I had sent email to you couple of times already.Thanks.
Lu,

I had sent email to you couple of times already.

Thanks.
--
test


"Wei Lu [MSFT]" wrote:


Submitted via EggHeadCafe - Software Developer Portal of Choice
BizTalk Configure and Send SMTP Mail Based on Message Within an Orchestration
http://www.eggheadcafe.com/tutorials/aspnet/4e9e7c92-1279-4fdb-8631-a2...9a021c2
 >> Stay informed about: To copy files from a folder to another folder