Get Reply from SSIS to intranet site when finished
Hi Experts
I have created a SSIS which grabs 3 flat files, removes some records then imports the data into 3 excel files. To do everything takes about 4 - 5 mins
I built a button on a intranet site so the user put the files into a directory and presses the button which calls a stored procedure which calls a job which executes the SSIS.
This all works great only the user has no way of knowing the SSIS is running, so I put in a client side spinner , so you see the spinner and know the website is working. At present I set it up on a timer (setTimeout(myTime, 4000)) which will wait and then hide the timer and let you know the files are ready (In theory that's what should happen) but the files are not always ready by then or they might have been ready a lot quicker.
My question: Is there away I can get a response from the SSIS which I can use as a trigger to know when the SSIS is finished to notify the user the files are ready.
Or maybe there is a completely different way of doing it which would work better.
Any suggestions will be greatly appreciated.
Thanks in advance
I have created a SSIS which grabs 3 flat files, removes some records then imports the data into 3 excel files. To do everything takes about 4 - 5 mins
I built a button on a intranet site so the user put the files into a directory and presses the button which calls a stored procedure which calls a job which executes the SSIS.
This all works great only the user has no way of knowing the SSIS is running, so I put in a client side spinner , so you see the spinner and know the website is working. At present I set it up on a timer (setTimeout(myTime, 4000)) which will wait and then hide the timer and let you know the files are ready (In theory that's what should happen) but the files are not always ready by then or they might have been ready a lot quicker.
My question: Is there away I can get a response from the SSIS which I can use as a trigger to know when the SSIS is finished to notify the user the files are ready.
Or maybe there is a completely different way of doing it which would work better.
Any suggestions will be greatly appreciated.
Thanks in advance
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I went with this approach but instead of looking for a file I counted the files in the directory so when they reach a certain amount I exited the timer
ASKER
That is exactly what I done. I ended up watching for the number of files in the directory and when it reaches the number expected then exit the timer. I am trying now to get figure out how to tell the user all files are ready