Uncategorized

I face an error while creation file location at my personal computer for

Could not store transport type data for Primary Transport of Send Port ‘SendPort1’ to config store. Primary SSO Server ‘ALIRAZA-PC’ failed. Cannot perform encryption or decryption because the secret is not available from the master secret server. See the event log (on computer ‘ALIRAZA-PC’) for related errors.
(Microsoft.BizTalk.ExplorerOM)

After doing google i found following solution.

REASON:
——-
Maybe someone had reset the service account password or any other cause.

———
SOLUTION:
———

If you get this SSO error:
Cannot perform encryption or decryption because the secret is not available from the master secret server, do the following steps:
1. Open command prompt:
2. Go to c:program filescommon filesenterprise single sign-on
type: ssoconfig -restoresecret SSO9F54.bak (the sso back up file created at the time of biztalk configuration)
3) Give the valid password

4)On success, type: ssoconfig -backupsecret latestbackup.dat
Give a password, and perform them successfully to take the backup of latest sso config file.

There are two ways to get content of message specified filed directly in BizTalk in message.

Distinguished fields and Promoted property.

Distinguished fields/properties

When you need to access  the content of filed only in orchestration level prefer Distinguished fields. Distinguished fields are xpath equivalent and these xpath stored insisted XSD.  Due these fields are xpath equivalent these are light weight. There are no restriction of size of filed.  There is common practice to use Distinguished properties instead of xpath, if any change in namespace of any schema, all xpath on the schema used in orchestration are lost. If you used distinguished properties then on update of target namespace all , distinguished proprieties also update and there will no change in orchestration.

When to use distinguished fields:

If you make decision, read values, update values of any message inside the orchestration Use distinguished properties.

Promoted Properties:

When required value of filed at port level then used Promoted properties. These Usually used for Routing purposes. When we promoted any field in Schema, these fields stored in separated Schema, known as Property schema. These have performance over head, due to these promoted values stored in Message box.  There is also restriction on Size of promoted properties the field size should not be exceed more the 256 character.

When to use Promoted Properties:

– Routing

– Tracking

– Correlating

– Driving built in pipeline component behavior

Use following Code

StreamReader sr = new StreamReader(@"d:simpleTabDelimeterFile.txt");
                StreamWriter outputFile = new StreamWriter(@"d:out.txt");
                string strline = "";            

                string[] _values = null;
                while (!sr.EndOfStream)
                {
                    strline = sr.ReadLine();
                    _values = strline.Split('t');
                    if( _values.Length == 3 )  
                    {
                        strline = _values[0] + 't' + _values[1] + 't' + _values[2];
                        outputFile.WriteLine(strline);
                    }
                }
                sr.Close();
                outputFile.Close();

There are hundreds of free SSIS tools available, which provide additional functionality. Codeplex listed them as http://ssisctc.codeplex.com/. These divided into following sections

• Tools
• Connection Managers
• Log Providers
• Task (for Control Flow)
• Foreach Enumerators
• Script Task Script Samples
• Components ( for Data Flow)
• Script Component Samples
• Sources
• Transforms
• Destinations

• MSDN Virtual Lab: Building Your First Cube with SQL Server 2008 R2 Analysis Services
• MSDN Virtual Lab: Building Your First Data Mining Model with SQL Server 2008 R2 Analysis Services
• MSDN Virtual Lab: Building Your First Extract-Transform-Load Process with SQL Server 2008 R2 Integration Services

Are you searching the download location for sample Databases for Microsoft SQL Server 2008R2 RTM (May 2010) ?

You can download it from Click here

It contains the complete set of databases:
– AdventureWorks
– AdventureWorks2008R2
– AdventureWorksDW2008R2
– AdventureWorksLT
– AdventureWorksLT2008R2