Hi there,
Does anyone know how i can keep an ssis package used for real time reporting alive no matter the amount of errors it gets? So for instance the server im streaming to is shutdown for maintenance, and the connection dies, its needs to just keep re-trying. In other words the maximum error count is infinite. i dont just want to set max err count high, i want it out of the picture all together.
Thanks
are you talking about a SSIS packages which do stuff inside a infinite loop?
|||yup thats the plan. i want the package to stay alive rather than calling it from a job over and over because of the validation time incurred in having the package start and end all the time|||
ssis might not be the one you need.
how about replication
|||We currently replicate. but due to performance issues starting to rear their heads, we have changed our structures on our ODS to include only data marts - therefore we need to transform all that gets replicated to our ODS|||replication should be able to catch up with that change. anyway. just stay for more suggestions.
how about scheduling the package to run regularly using a Sql jobs or windows task scheduler
|||Thanks for the reply. Yup gonna go with scheduling it. slower than i initially wanted but will prob be the only way
No comments:
Post a Comment