Link to home
Start Free TrialLog in
Avatar of Bharat Guru
Bharat Guru

asked on

how to continually checking the NT folder from sql server

How to continually checking the NT folder from SQL Server and Once the file is in c:\load directly I want to call the SSIS package to load the data into the table.
Avatar of Deepak Chauhan
Deepak Chauhan
Flag of India image

You can do it in multiple steps.

1. Create a job which will check file exists at the location or not , if exists this job will run the SSIS package job. You can schedule this job at 5 minutes or 1 hour interval this is depend on file presence possiblity.

2. Add a step in SSIS package job which will rename or move the file from original location to another location let says backup location so that file can not be start loaded again.

Let me know if further help needed.
Avatar of Bharat Guru
Bharat Guru

ASKER

I want to run the package soon as file loads
ASKER CERTIFIED SOLUTION
Avatar of Deepak Chauhan
Deepak Chauhan
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial