Post reply

LOOK FOR FILE IN FOLDER - IF prsent DO REST OF THE STEPS ELSE End Package Execution

  • August 28, 2008 at 4:41 pm

    #192197

    Now I need a way to stop my package at th every beginning if there is no file present in the folder. Basically , i have to load files to my stage table and from stage i have to do all sorts of transformation and so on.

    SO i ahve all kind of different tasks .

    Now At the beginning of the package I want to have a task to check for file in the folder, If present then continue for rest of the task , else if file is not present just finish teh package.

    IS there a code for script task or can i do from other task.

    Thanks

  • August 28, 2008 at 6:36 pm

    #864781

    You can check it in a script task

    System.IO.File.Exists(filename)

    You can store the value in package variable and take further actions depending on this variable, e.g send mail and disable further steps.

    HTH

  • August 29, 2008 at 7:33 am

    #864999

    Mukti... Once again thanks, U have been a graet help all this time.

    The problem is I am very poor at coding and I don't know how to do it with Script task.

    I can thing of other task like WMI event watcher task to do the same thing, but again, I am trying to avoid more connections and more complexcity.

    If You could take some time out and post the code for me, It would be a great help.

    Thanks

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

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