Home > Articles > Data > SQL Server

  • Print
  • + Share This
From the author of

From the author of

Utilize Workflow

It is possible to build a package that uses no workflow. DTS will execute all tasks in parallel. At first glance this may seem like a good idea, but you can get yourself into trouble by trying to update related tables in the wrong order. So, always use workflow to intentionally set which tasks and data changes are parallel and which ones are serial.

  • + Share This
  • 🔖 Save To Your Account