January 27, 2021
Hot Topics:

Building a Windows Workflow SQL Server Integration Services Activity

  • By Jeffrey Juday
  • Send Email »
  • More Articles »

Once Package execution completes, the SSIS_Services takes over, posting the text "Done" to the WorkflowQueue set up by the SSIS_Activity, invoking the OnEvent function in the SSIS_Activity, and the SSIS_Activity closes.


Windows Workflow Foundation gives a developer deep access to the .NET Framework, as well as a foundation for building workflows for all types of scenarios. Unfortunately, workflow style tools such as SSIS are not implemented in WF. You can fix this by building your own WF SSIS_Activity,; leveraging the features of WF and the SSIS Object model.

Download the Code

You can download the code that accompanies this article here.


About the Author

Jeffrey Juday is a software developer specializing in enterprise integration solutions utilizing BizTalk, SharePoint, WCF, WF, and SQL Server. Jeff has been developing software with Microsoft tools for more than 15 years in a variety of industries including: military, manufacturing, financial services, management consulting, and computer security. Jeff is a Microsoft BizTalk MVP. Jeff spends his spare time with his wife Sherrill and daughter Alexandra. You can reach Jeff at me@jeffjuday.com .

Page 4 of 4

This article was originally published on October 27, 2008

Enterprise Development Update

Don't miss an article. Subscribe to our newsletter below.

Thanks for your registration, follow us on our social networks to keep up-to-date