How can I schedule SSIS package based on event in real time

  • Hello all,

    We have the scenario where we need to load the data in real time application.

    We are getting the data in HL7 format.

    Once we get the data it should be trigger the SSIS package.

    thanks and Regards,

    gajendra

  • Hi Gajendra,

    You can setup a script task to watch the source directory for new files. This is a common use case for a FileSystemWatcher which can be programmed to poll the source directory at regular intervals

    Raunak J

  • Hi Raunak,

    I agree with file system task or window event task but how we can access the data in HL7 format or Json format as source.

    or else

    my developer told that he can pass the data in parameter through C# but how we can split the data in Script component.

    Could you please help me out for this.

    Thanks and Regards,

    Gajendra

  • Hi Gajendra,

    What kind of process do you wish to run with JSON (JSON like) files. The file system watcher will trigger the workflow when there is a file available at source?

    Raunak J

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

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