Suneet Nangia Blogs & Beyond...
Suneet Nangia Blogs & Beyond...
Tags
Archives
Skip Navigation Links.
Feeds
RSS 2.0
About Me
Hello,
I am Suneet and this is my personal web space to put my views and tips on cutting edge MS technologies and otherwise at times. I am sort of a mouse potato who would stick to his PC for hours. I love playing badminton, table tennis and roller skating.
Incase you want to ping me for anything, get in touch at techie@suneet.net.
 
Making of the beast...
Photography Freaks
My Other Spaces
 
Flickr Photo Albums
Created especially for my new EOS 40D
Interesting Articles
 
Richard Grime's .Net Security
Extremely good .net security article. I have never come across any such tutorial before.
What Leads to EAI
MS Journal Article
Blogs I Visit
 
Stephen W. Thomas

Kevin B Smith
 
Saravan Kumar

John Flander

Biztalk Server Team

Darren Jefford

Daniel Moth
I have attended few of his workshops@ MS, Thames Valley. Very sharp fella with good programming knowledge.
Mike Taulty

Richard Grime

Chris Dickson
One line for him- Fantastic Biztalk & .Net Expert. I had a chance to work him, he is one person who will always do the right things rightly.
Mohit Nayyar
Exciting MS SQL/DB blog
Ben Cops
He is techincally very sound person with good balance between work and life.
Technical Readings
 
BizTalk 2006 Recipes

Pro BizTalk 2006

Microsoft BizTalk Server 2004 Unleashed

CLR Via C#
Amazing book on core concepts of CLR and C#. Must have book.
Jeffrey has finished its 3rd edition as well which will soon be in the market. Follow this link for its release dates, availability etc
BLOGs-
All Months, All Years Showing Page 1 of 8
Fri, 04 Jun 2010 11:21:30 GMT
Message Context Lost After Call Rules Shape

Another problem I faced while working on BRE recently.
If you call BRE from orchestration using Call BRE shape and pass in the message into it, the message lose all its context and you cannot access it after it. It seems Call BRE shape creates new message out of the passed XLangMessage and points the same message variable to it.

Solution: Just extract all values from the context before you make a call to BRE.



Comments(0) | Permalink | Biztalk 2004/2006/2009

Thu, 20 May 2010 16:55:00 GMT
Map project does not compile on BizTalk 2009 build server

While working on the new project on BizTalk 2009 I came across this compilation error on the build server which had only "Build Components" of BizTalk deployed on it as suggested by documentation.

Our map project was throwing the following error while compiling-

Error: XXXX.btm : error btm1023: Exception Caught: The map contains a reference to a schema node that is not valid. Perhaps the schema has changed. Try reloading the map in the BizTalk Mapper. The XSD XPath of the node is: /*[local-name()='']/*[local-name()='XXXXXXX']/*[local-name()='XXXXXXXX']/*[local-name()='XXXXXXX']/*[local-name()='XXXXX']

Map project was building correctly on development machine but failing on this build server.

Resolution: Install SDK and Developer Tools components of BTS as well on the build server.


Comments(3) | Permalink | Biztalk 2004/2006/2009

Thu, 15 Apr 2010 22:51:25 GMT
SSO Config Error in BizTalk Server 2009. Failed to connect to the SQL Database 'SSODB' on SQL Server

While configuring BizTalk 2009 eval copy on my development machine, I faced the following error in the event log-
Login failed for user 'xyz' SQL error '18456'

And following error in the config console-
Failed to connect to the SQL Database 'SSODB' on SQL Server 'abc'

You get this error when a 'SSOSQL.dll' is unregistered on the machine. To register it back use the following command from the visual studio command prompt-
'Regasm SSOSQL.dll'

Note: Make sure you change the current directory in the prompt to the location where this dll is present i.e. "C:\Program Files\Common Files\Enterprise Single Sign-On\"

Another thing I noticed was that when I installed BTS before installing VS 2010 it was configured smoothly but somehow I guess VS 2010 unregistered the SSOSQL.dll file.


Comments(0) | Permalink | Biztalk 2004/2006/2009

Thu, 20 Aug 2009 13:40:10 GMT
"data rows to skip" bug in SSIS Flat File Connection Manager

SSIS 2005
Flat File Connection Manager Bug-
I was bit shocked to see this bug which MS is still reluctant to fix.

If you change the "data rows to skip" settings under "Preview" tab it will impact how the rows are imported actually using a file and is not just confined to the preview of the data in that window. Essentially, if you set it to say 100, the package when executed will skip 100 rows from the file and guess what not just from beginning but also also the random positions as well.

If MS says this is a minor UI bug then the question is why is it skipping rows from the random positions also and not just from the top?? I am sure no developer will like to skip random rows from the file :)

It is a BUG indeed.



Comments(0) | Permalink | SSIS
Showing Page 1 of 8