Post reply

package instantiation

  • January 19, 2009 at 1:07 am

    #128051

    Hi ALL,

    My problem is when file come in to the folder i need to execute a package.Files will come every one hour in a day.I need to run pacakge every five minutes.So for that i need multiple instantiation of a package if the package already in process.If new files come i need to execute once again separately.Any idea on this?

    Thanks & Regards,

    Ramu

  • January 19, 2009 at 2:20 am

    #929061

    Here is something that you can try....

    1. Create a sql job of OS command type.

    2. Write the below command:

    Start cmd /c dtexec /f "[package name]"

    This command will call a create command shell (asynchronously) and will call the dtexec to execute your package. While the package is executing the job will get completed.

    -Vikas Bindra

  • January 19, 2009 at 8:11 am

    #929247

    You might investigate using the file watcher task - check this thread for more details:

    http://www.sqlservercentral.com/Forums/Topic493253-148-1.aspx

    Phil

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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