Is it safe to run several SSIS packages in parallel in a multithreaded application? The package objects are not accessed from multiple threads: every thread is handling its own package (see below).
void task_inside_thread()
{
System::String ^s = "...";
Microsoft::SqlServer::Dts::Runtime::Package p;
p.LoadFromXML(s, nullptr);
// callback handler
MyEventsClass ^ eventsClass = gcnew MyEventsClass();
DTSExecResult result = p.Execute(nullptr, nullptr, eventsClass, nullptr, nullptr);
return;
}
Is there any relevant documentation with respect to this issue?
Thanks,
Bogdan
Yes, this should be safe, packages are independent of each other.|||I worried more about the fact the package instances might use global objects for registration and for signalling their current status.
Thanks for your answer.
Bogdan
|||Yes, they sometime do. I have to re-phrase it - they behave as independent objects, taking care of locking global state when needed.