File System Task

Question

File System Task

patla4u

SSCrazy

Points: 2103
More actions
June 29, 2011 at 12:23 pm

#252752

I have 10 different File with Diffetent Name.
I want to move that file from download folder to archive folder with current month and Year Information.
How can I move and rename with all 10 different files with Different Names?
LIke
I have acct.txt, trans.txt. acctaddr.txt ...... in download folder.
and I want in archive folder with 06_2011_acct.txt,06_2011_trans.txt ,06_2011_acctaddr.txt.
I want to use only one file system task.......How can i do ?
I have to use for each loop container also?? how ???
Any one can semd me particular link or can explain ....that would be helpful.
Thanks
L

Viewing 15 posts - 1 through 15 (of 16 total)

You must be logged in to reply to this topic. Login to reply

Robert Klimes SSCoach Points: 17865 More actions · Answer 1

If you are looking to do this in SSIS here is a link that will get you started. http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx.

Bob
-----------------------------------------------------------------------------
How to post to get the best help[/url]

patla4u SSCrazy Points: 2103 More actions · Answer 2

THanks for replying me

but I need a specific example.

please any one can provide me Detail.

THanks

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

That example is pretty specific.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 4

As stated you can use SSIS.

An SSIS For Each Loop Container and a Script Task with the File System Object will do it.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Ashok Teotia SSCrazy Points: 2407 More actions · Answer 5

patla4u (6/29/2011)
I have 10 different File with Diffetent Name.
I want to move that file from download folder to archive folder with current month and Year Information.
How can I move and rename with all 10 different files with Different Names?
LIke
I have acct.txt, trans.txt. acctaddr.txt ...... in download folder.
and I want in archive folder with 06_2011_acct.txt,06_2011_trans.txt ,06_2011_acctaddr.txt.
I want to use only one file system task.......How can i do ?
I have to use for each loop container also?? how ???
Any one can semd me particular link or can explain ....that would be helpful.
Thanks
L

Ashok Teotia SSCrazy Points: 2407 More actions · Answer 6

Hi,

This is not possible with Single file system task beacuse move file operation do not include file name thats file you will have to use two file system tasks one for copying the file and another to delete the file.

That is logical as well because moving the file would not be preferable choice in this case.

If you wish I would post you the solution for the same.

Regards

Ashok

Ashok Teotia SSCrazy Points: 2407 More actions · Answer 7

I want to use only one file system task.......How can i do ?
L

This can only be possible with two file system tasks..

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 8

ashok.faridabad1984 (6/30/2011)
I want to use only one file system task.......How can i do ?
L
This can only be possible with two file system tasks..

You are joking right? 🙂

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Ashok Teotia SSCrazy Points: 2407 More actions · Answer 9

I am not serious It does not mean I am joking, If you wish to prove mettle, you can share such a solution, I would be grateful to you..

Regards

Ashok

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 10

Robert klimes (6/29/2011)
If you are looking to do this in SSIS here is a link that will get you started. http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx.

Start by creating an SSIS Package using the example that Bob provided you.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Ashok Teotia SSCrazy Points: 2407 More actions · Answer 11

:-D, This is joke of the Day, We should also have a regular post of this kind....

This doest not match anywhere what is the exact requirement.

patla4u SSCrazy Points: 2103 More actions · Answer 12

Thank for replying me ,..

but you can do it by for each container and file system task ....

Thanks

L

Wildcat SSCarpal Tunnel Points: 4774 More actions · Answer 13

patla4u (7/1/2011)
Thank for replying me ,..
but you can do it by for each container and file system task ....
Thanks
L

1. Put a ForEach Loop Container

2. Put a File Systeam Task in the ForEach container.

3. Choose "Move file" as the operation in File System Task.

4. DONE

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 14

Welsh Corgi (6/29/2011)
As stated you can use SSIS.
An SSIS For Each Loop Container and a Script Task with the File System Object will do it.

Go for it...

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/