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

Question

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

gajendrachoubey 42015

SSC Enthusiast

Points: 173
More actions
November 27, 2014 at 4:03 am

#298851

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

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

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

Raunak Jhawar SSCoach Points: 15701 More actions · Answer 1

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

gajendrachoubey 42015 SSC Enthusiast Points: 173 More actions · Answer 2

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

Raunak Jhawar SSCoach Points: 15701 More actions · Answer 3

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