Post reply

File existance in folder

  • September 27, 2010 at 7:52 am

    #145408

    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

  • September 27, 2010 at 8:06 am

    #1227698

    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

  • September 27, 2010 at 8:17 am

    #1227707

    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[/url]

    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.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • August 22, 2013 at 10:19 am

    #1644033

    try Long Path Tool

Viewing 4 posts - 1 through 3 (of 3 total)

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