Post reply

file count

  • September 23, 2008 at 9:42 am

    #198379

    I need to count no. of files in a directory and if no. of files more than 3 then execute dts package , if not then don't

    is this can add in sql agent job?

    need your suggestion and solution..

  • September 23, 2008 at 9:51 am

    #875839

    You can do this in a job-

    Set first step to type ActiveX Script and create code (using the Scripting.FileSystemObject) throw an error # of files are not there.

    Second step will be to run your package...if the first step fails, it won't reach this point.

  • September 23, 2008 at 10:00 am

    #875852

    can you tell how to do activescript?

  • September 23, 2008 at 10:43 am

    #875892

    Activescript is used for Adobe Flash my friend. 🙂

    On the other hand, ActiveX scripting is very a large arena, and not something one can teach you in one forum post. If you cannot find someone who knows VBScript or JScript (types of activex scripts) to help you, you can google the following things:

    VBScript and Scripting.FileSystemObject (used for file/directory manipulation)

    VBScript and Err.Raise (used to raise errors)

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

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