Hey guys I have a job which runs an SSIS package. But as this package needs to run everytime a file is uploaded, I was wondering if sql jobs can help in here...
Does anyone know how can i schedule this job which executes an ssis package frm .net 2005?
Or
Can i write a custom schedule for a job which will check if certain value has changed in the table if yes run the job if no just wait
or do u guys have any suggestions or pointers...
Regards
You could use notification services to file when the upload completes, then have a job start your SSIS package when the message arives in the queue.
No comments:
Post a Comment