what is best way to execute dtsx package from biztalk .
1: use biztalk to load from file system then execute from orchestration.
2: should be preloaded into sql instance ,use only biztalk for execute package(using C#).
3: create sql job , then trigger this job from biztalk orchestration.
4 : create stored proc for execute dtsx package ,only use biztalk to execute stored procedure.
please suggest the best way with all possible pros and cons.
Calling SSIS through SQL stored procedure from BizTalk:
Calling SSIS from .NET:
Pro: Standard way for calling external objects/entities
Create SQL job , then trigger this job from BizTalk orchestration
I would consider using
calling SSIS through SQL stored procedure from BizTalk. You have some options now, see which one can suit your environment and requirement better.
If this answers your question please mark it accordingly. If this post is helpful, please vote as helpful.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?