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.
ASKER
I want to run the package soon as file loads
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.