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

activitymonitor



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.

Read More ...

Posted by Mark on 27-10-2009 and Filed under: SQL
3 comments

BizTalk: Missing context property ReceiveLocationName within orchestration

image



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.

Read More ...

Posted by Mark on 02-09-2009 and Filed under: BizTalk
3 comments

C#, .NET: Current Directory for Windows Service

cat_icon_files_256



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 ...

Posted by Mark on 01-09-2009 and Filed under: .NET, C#
3 comments

BizTalk: Call Rules shape grayed out

image
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 ...

Posted by Mark on 24-08-2009 and Filed under: BizTalk
3 comments

SQL, SSIS: Execute SSIS Package within Stored Procedure

image



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.

Read More ...

Posted by Mark on 21-08-2009 and Filed under: SQL, SSIS
5 comments