question

FarhanJamil-5363 avatar image
0 Votes"
FarhanJamil-5363 asked Zoehui-MSFT answered

need advise on ssis

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Zoehui-MSFT avatar image
0 Votes"
Zoehui-MSFT answered

Hi @FarhanJamil-5363,

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


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.