Building a Windows Workflow SQL Server Integration Services Activity

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.

Conclusion

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.

Resources

• "Building a Custom Activity:" http://www.developer.com/net/net/article.php/3658371
• "Windows Workflow Foundation Programming Guide:" http://msdn.microsoft.com/en-us/library/ms734702.aspx
• "Using the SQL Server 2005 Integration Services Class Library:" http://www.codeguru.com/columns/experts/article.php/c11047
• The File System Watcher Activity Sample: http://msdn.microsoft.com/en-us/library/ms741707.aspx
• Collection of MSDN Workflow Articles: http://msdn.microsoft.com/en-us/magazine/cc159299.aspx

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