I am writing a package where the user uploads a flat file to a web folder. I need to automate this package to run everytime it sees a new file.
How can I implement this?
Can I make a call to a package or a sql server job to run from .net 2.0?
Do I need to use a service broker to look for a new file and run the package or a stored proc....I am looking for an async process where user doesnt have to wait for the package to run as it involves data validation of flat file and its huge...
Please help!!
How about a scheduled package that runs every minute, and if it finds a file it runs the load task, otherwise it just ends.
You could do something event driven with the WMI event task, but I dislike that since it does not tell you what file has been found, or try the File Watcher Task (http://www.sqlis.com/default.aspx?23)
|||Appreciate your response...
I was wondering about creating a config file in the database and update the Connection string value everytime a new file is uploaded with the new file name
And then call the package to run by adding dts assembly to visual studio and doing package.load....
Any suggestion or comments on this as I really dont want to run this every min....
No comments:
Post a Comment