Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

File existance in folder Expand / Collapse
Author
Message
Posted Monday, September 27, 2010 7:52 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, December 15, 2014 11:14 PM
Points: 1,085, Visits: 721
Hi,

Now i got a chance to work on SSIS. I am very beginner to SSIS.

Could you please help me in the following scenario.

If the file existed in Remote place then it should be moved to Archive folder with MonthDate as postfix of that file.

IF exist e:Personal\test\Test.txt
MOVE e:Personal\test\Test.txt to e:Personal\testArchive\Test0927.txt

Please give me step by step in detail.I will follow these steps as it is.

Thanks,
Sasidhar P
Post #993653
Posted Monday, September 27, 2010 8:06 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:56 AM
Points: 5,487, Visits: 10,335
Sasidhar

Have a play with the File System Task - that should be able to do what you require. You can use variables and expressions to build the names of the files with dates in. Please post back if there's anything in particular you don't understand.

John
Post #993659
Posted Monday, September 27, 2010 8:17 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 10:51 AM
Points: 1,510, Visits: 8,470

Also, take the time to learn about how to do things using SSIS before jumping in. Also, learn how to do internet searches. I did a quick search and the 2nd link in the results was probably one of the best explanation of how to check if file exists.

Many of us here are quite willing to help others. Some of us will not rush to help those that show no sign of having tried to help themselves.




Alvin Ramard
Memphis PASS Chapter

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.
Post #993670
Posted Thursday, August 22, 2013 10:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 22, 2013 10:12 AM
Points: 5, Visits: 0
try Long Path Tool
Post #1487394
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse