need advise on ssis

Farhan Jamil 416 Reputation points
2021-09-21T07:26:48.887+00:00

Hi All

I am not sure how to proceed on this but i have a ssis requirement.

I work in a retail company and i get sales file from the client on a daily basis.

What i want to achieve

As soon as a file is dropped on source folder location , an event i guess should be called which should run the sql job to run the ssis package i have it already in place to process the sales file.
In this way I dont have any dependancy to run the sql job at certain time.

Is it possible to achieve this.

Any question please let me know

Regards
farhan jamil

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,452 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 32,736 Reputation points
    2021-09-22T02:25:25.347+00:00

    Hi @Farhan Jamil ,

    Here is a same thread about your requirement, you may take a carefully reference.

    https://stackoverflow.com/questions/21436377/how-to-execute-ssis-package-when-a-file-is-arrived-at-folder

    Also you could use WMI Event Watcher Task.

    https://stackoverflow.com/questions/27196678/triggering-execution-of-ssis-package-when-files-arrive-in-a-folder/27241792

    Regards，

    Zoe

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October

    0 comments