October 21, 2014
Hot Topics:
RSS RSS feed Download our iPhone app

Building a Windows Workflow SQL Server Integration Services Activity

  • October 27, 2008
  • 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.

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

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



Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 


Sitemap | Contact Us

Rocket Fuel