sql server dts: From my brief experience with SSIS, I gather that packages are meant to
execute, perform the job, and end. I'm currently using the SQL Server Agent
to kick off my package on an interval, however I would like to be able to run
my package in a real time manner to process data as it comes in, possibly
from some connection. Is it feasible to have a package that acts as a daemon
and never ends? Are there issues with memory consumption?

Hello,

I understand that you'd like SSIS package runs as daemon to process data
continously. If I'm off-base, please let me know.

Based on my knowledge, you could use "for loop" container and put the task
you want in it so that the tasks could run in a loop unless some condition
meets. You could use script task to monitor the condition you want and
change the variable to exit the loop.

Usually package running shall not cause memory issue because it only uses
cache in the backgroud and shall not leak memory when running.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================



This posting is provided "AS IS" with no warranties, and confers no rights.

Hello Hasan,

Yes you can most certainly do this although I do not believe it is a scenartio
that MS did much testing on. i have worked with clients and built custom
Source Adpaters and tasks which open and do not close (well they do but you
usually set it for a long period if time before it does so).

I do not see issues with memory and resource consumption either.


Allan

[quoted text, click to view]