Mark Barto's Blog
Technical Blog about the Microsoft .NET Platform and everything that surrounds it such as .Net, C#, BizTalk, WCF, ASP.NET, SQL, Silverlight, IIS ...SQL: Activity Monitoring missing within SSMS
When searching for the Activity Monitoring within SQL Server Management Studio 2008 under the management folder you determined that it isn't there anymore. After some research I came across an interesting article where is explained where you can find the Activity Monitor.
BizTalk: Missing context property ReceiveLocationName within orchestration
We have noticed that when you are transforming a message within an orchestration that the context properties of the original message will not be copied to the transformed message. You must declare this specific within your expression shape of your orchestration.
Because we are using ESB for exception handling we want to know the location where the message is coming from.
Unfortunately the ReceiveLocationName is missing in the standard BTS namespace.
C#, .NET: Current Directory for Windows Service
When calling for the current directory in a Windows Service with the Path.GetCurrentDirectory() you will probably not getting the correct directory but the C:\Windows\System32 directory.
Read More ...
BizTalk: Call Rules shape grayed out
When trying to use the call rules shape within my orchestration I have noticed that when right-clicking on your orchestration the call rules shape was grayed out.
Read More ...
SQL, SSIS: Execute SSIS Package within Stored Procedure
I have a stored procedure which returns data from a database. Before I want to return this data I want to execute a SSIS package which populate this data. Unfortunately there is not any SQL statement to start a SSIS package within a Stored Procedure. But there is a work-a-round for it.