About Workflow Engine in SQL Server

Hi,

What is workflow engine in Microsoft Sql Server? it is called "workflow engine" or "workflow designer"?

If i wish to use workflow engine in Sql Server, which version of Sql Server i should use? do 2000 version support?

And if i purchase a Microsoft Sql Server software, does the CD contain / bundle the workflow engine together?

Thanks in advance

Peter Lah.

I'm not exactly sure what you mean by a "workflow engine". What are you trying to accomplish? In SQL2K there's a tool called DTS (Data Transformation Services) which allows you to move data around, transform it, in a workflow like fashion. In SQL2K5 this was replaced with Integration Services. The DB Engine has a component called SQL Server Agent which is a job scheduler; each job can have multiple has steps each which perform a task. Agent is available in both SQL2K and SQL2K5.

Cheers,

Dan

|||
Thanks for replied, the term "workflow engine" which i refered is from :
"The Workflow Engine Model" http://msdn2.microsoft.com/en-US/library/aa164772(office.10).aspx
The acticle said that "The workflow engine is a component in the Workflow Designer for SQL Server infrastructure that makes workflow possible."

Is it the above info is refer to the DTS(Data Transformation Services) in SQL2K, or the Integration Services in SQL2K5?

Will the Integration Services bundle together into SQL2005 CD if i purchase the software? or should i upgrade somewhere?

Thanks again
Peter lah.

|||PLease do not post duplicate posts for same problem, refer tohttp://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2191866&SiteID=1 fyi on above issue.|||

Peter - The Workflow Engine referenced in the article is a separate product that effectively creates triggers in SQL Server to automate a sequence of work.

Thanks -

Buck Woody - SQL Server Team