Biztalk Adapters

51 of 1109 | EF POCO Adapter updated (v1.02) - I've just posted updates to EF POCO Adapter (v1.02) which resolves a couple of issues spotted by users: Detached proxies (created by EFPocoContxt.CreateObject<T>) as well as proxies in the Added state were failing on property navigation. This has been fixed, and the property navigation doesn't attempt the load in one of these states. Thanks to Corey Gaudin for reporting this. GetAdapterObject() was failing for proxies created with CreateObject<T>. This has been fixed by ensuring that adapters are always cached whenever proxies are present. As a side effect of this change, DetectChanges() should be a bit faster, as we don't have to walk object state manager anymore. Thanks to Co......

52 of 1109 | ATTO intros quad-channel 8Gb Fibre Host adapter - ATTO Technology's new Fibre Channel host adapter is billed as the industry's first 8Gb model. ...

53 of 1109 | Commerce Server 2007 Training Resources. - One of the questions I am commonly asked is "Where can I learn more about Commerce Server?". I mentioned this topic briefly on my post Starting to look at Commerce Server. So if you're new to Commerce Server where can you start? The first place I would start is the Commerce Server Developer Center on MSDN. The documentation for Commerce Server 2007 covers a lot of the basic concepts and ideas that you will need to know around the main Commerce Server Systems. Introducing Commerce Server 2007 Then we can start to look at the concepts of each of the Commerce Server 2007 systems. Concepts of the Catalog System Concepts of the Inventory System ......

54 of 1109 | Linux Integration Components Now Posted! - While I'm recovering from the Virtualization Launch Event here in Bellevue yesterday (you can view the keynote sessions and all the breakouts here), there's even more Hyper-V news to share. My colleague Patrick O'Rourke had posted previously on this, but I'm proud to announce - The final version of the Linux Integration Components for Hyper-V have been released! Driver support for synthetic devices: The Linux integration components include support for both the synthetic network controller and synthetic storage controller that have been developed specifically for Hyper-V. These components take advantage of the new high-speed bus, VMBus, which was developed for Hyper-V.Hypercall adapt......

55 of 1109 | Announcing the release of the Solution Connector for Microsoft Office Project Portfolio Server 2007 on MSDN Code Gallery - The Solution Connector for Microsoft Office Project Portfolio Server 2007 has been released on MSDN Code Gallery: http://code.msdn.microsoft.com/PPSSolutionConnector This solution starter was created to support both the Capital Planning & Investment Control for Federal Government (CPIC) and Innovation Process Management (IPM) solutions. In these solutions projects and ideas are captured in SharePoint and at a specific point in the workflow  pushed to Project Portfolio Server 2007 (utilizing the new web-service) for analysis. The Solution Connector is an ASP.NET web service and .NET class library which provides a set of methods for programmatically creating, updating or deleting ......

56 of 1109 | Building Enterprise Mashups using RSSBus - Microsoft MVP Richard Seroter started a series of posts on building enterprise mashups using RSSBus.  Part 1, and Part 2. A few weeks ago our Executive Director / Chief Architect / Technology Overlord recently asked me to build a real, live enterprise mashup application to demonstrate for our IT leadership group. Our goal was to show that RSSBus could be used to quickly and efficiently aggregate data in compelling new ways.   In the next few posts, I’m going to walk through our use case, and how I built a solution to solve this. In this first post, Richard provides an outline of his problem, the solution he decided on, and how he would use RSSBus to help accomplish his goal. In the......

57 of 1109 | Multiple Stored Procedure Calls using the BizTalk SQL Adapter without a loop shape - Alright, now that the New Zealand Tech Ed is done and dusted people around here are back at blogging, including me. I thought I’d start with one that’s been on my list for a while: how to make multiple calls to the same stored procedure using...(read more)...

58 of 1109 | Strange FTP Adapter Error - Recently I got these two errors with EventID 5740 from a FTP Receive Location: The adapter "FTP" raised an error message. Details "WARNING: An unexpected failure occurred when attempting to disconnect from the remote FTP server. The error code was 0x8004200C ". The adapter "FTP" raised an error message. Details "A failure occurred when parsing the remote folder listing. ". The strange behaviour was that BizTalk got alle files from the Receive Location, succesfully processed it and after some minutes the Receive Location was shut down. I finally found out that there problem was a problem with the file mask - after changing the mask from *.xml to *.* (which was......

59 of 1109 | BizTalk 2009 - The next version. - Following on from BizTalk Server 2006 R2 released on October 2, 2007,Microsoft has been working on BizTalk Server 2006 R3. In a recent announcement Microsoft  renamed it to simply BizTalk Server 2009.  It is scheduled to be released in the first half of next year. A first community technology preview (CTP) has already been sent out to select BizTalk customers, and a second public CTP will be available later this year at PDC. Oliver Sharp, general manager of BizTalk Server, stated that BizTalk Server 2009 will be a full release of the product that takes advantage of Windows Server 2008, Visual Studio 2008, SQL Server 2008, and .NET Framework 3.5: In particular the platform updates ......

60 of 1109 | Building Enterprise Mashups using RSSBus: Part II - In the previous post, I laid out a data visibility problem and proposed using RSSBus to build an enterprise mashup that inflates a single data entity whose attributes reside in multiple disparate systems. Before a mashup can be built, we actually need the source data in a ready-to-mashup format.   For the mashup I am building, my “contact” data resides in 3 different repositories: Database containing the interactions we’ve had with a particular contact Web service talking to a CRM system which holds core contact information Excel spreadsheet containing external reference data such as the contact’s public web page and blog On top of this, my mashup will also return a Google result set base......

61 of 1109 | BizTalk Talk (Speech) Adapter - Screencast and download - So BizTalk can walk the walk, -but can it TALK the TALK? I sincerely hope this adapter will come to the rescue, upon deploying your mission critical solution. Yes I know, I got to much spare time...but here is the download ....(read more)...

62 of 1109 | Getting started with NUnit and BizUnit - When it comes to testing your BizTalk applications, NUnit and BizUnit are often used. Where NUnit is a unit-testing framework for .NET languages, BizUnit can be used for testing your BizTalk 2004/2006 solutions. This article describes which tools need to be installed and helps you to setup your first test project.What is NUnitAs stated, NUnit is a unit-testing framework for .NET languages. The test cases you create with BizUnit are added to and executed from the NUnit user interface. The results from the test runs can be viewed in NUnit as well.What is BizUnitThe test cases you need to test your BizTalk solutions are created with BizUnit. Although you need to create a Class library in Visua......

63 of 1109 | Hate Add-Member? (PowerShell's Adaptive Type System to the Rescue) - Do you hate Add-Member as much as I do? Wait - maybe you aren't familiar with Add-Member or the glory of PowerShell's Adaptive Type System.  (ATS).  When I looked at the .NET type system, my reaction was "....almost".  I'm not trying to throw a rock at .NET - anyone that knows me knows how much I love .NET but the reality is that it's type system "almost" meets the needs of a management system ... but doesn't.  That is why we invented the Adaptive Type System.  There are 4 main components of ATS: Type Adapters.  A lot of technologies implement their own type systems within .NET.  Most of these technologies are critical to Management scenarios (WMI, A......

64 of 1109 | Two great articles about the Oracle adapter - Last week I had to help a collegue with the Oracle adapter. To get started I used the following 2 articles:Richard Seroter's Walkthrough Wilfried Mausz's Oracle adapter demoThese two articles and some general BizTalk knowledge helped me to understand most of the Oracle adapter in very little time.Sharing knowledge rocks! Thanks guys! ...

65 of 1109 | BizTalk get's a new logo (oh - and a new version too!) - Microsoft has announced the next major version of BizTalk - BizTalk Server 2009. Planned to be released 'H1 CY09', the new version, previously referred to in some circles as BizTalk "R3", adds support for the latest Microsoft stack - Windows Server 2008, SQL Server 2008, Visual Studio 2008, .net framework 3.5 and TFS 2008 - including automated builds and continuous integration as well as virtualisation using Hyper-V. There are also further investments in B2B (EDI, SWIFT), RFID, enhanced LOB adapters and support for UDDI 3.0 Next CTP is planned for sometime in the last quarter of this year, while previously Microsoft announced that BizTalk '6' will be part of the 'Oslo' wave......

66 of 1109 | BizTalk Server 2009 - Today, we announced updated plans for the next major version of BizTalk Server. We launched the first version of BizTalk Server back in 2000.  Eight years later, we’ve seen our installed base grow to 8,200 customers making it the most widely deployed solution for enterprise connectivity in heterogeneous environments. We’re hearing from our customers that BizTalk has become a core part of their infrastructure, running mission critical applications. Our partners (over 1500 of them) tell us that the applications and adapters they build for BizTalk have become a significant part of their business. This positive feedback is our greatest reward.   We’re excited to offer more details o......

67 of 1109 | Building Enterprise Mashups using RSSBus: Part I - I’ve been a fan of RSSBus from /n software for some time. A few weeks ago our Executive Director / Chief Architect / Technology Overlord recently asked me to build a real, live enterprise mashup application to demonstrate for our IT leadership group. Our goal was to show that RSSBus could be used to quickly and efficiently aggregate data in compelling new ways.   In the next few posts, I’m going to walk through our use case, and how I built a solution to solve this. Before getting into the “what” and “how”, I want to first say that the “how I built a solution” line above isn’t entirely true.  The folks at RSSBus actually built most of the solution for me, and all I did was tweak and customi......

68 of 1109 | Den tredje Acceleratorn - Enterprise Search - Den tredje Acceleratorn vi kommer att släppa är Enterprise Search Accelerator. Den ser till att nyttja både Dynamics CRM, Business Data Connector samt Sharepoint och gör det möjligt att söka igenom flera entiteter samtidigt. Dessutom är det möjligt att söka igenom flera olika andra datakällor samtidigt som du söker i Dynamics CRM. Enterprise Search Acceleratorn är ett bra exempel på hur du kan använda Sharepoint som ett alternativt...(read more)...

69 of 1109 | Microsoft Announces BizTalk 2009 - Microsoft has announced that the release of BizTalk server previously referred to as "BizTalk Server 2006 R3" has been upgraded to a full release to "BizTalk Server 2009".  New features for this release fall into four areas: B2B Integration - mobile RFID support, enhanced RFID device support, improved AS2 and EDI support, Drummond certification & updated SWIFT support with Gold certification. Updated Platform - support for .Net 3.5, VS 2008 SP1, Windows Server 2008 & SQL Server 2008. SOA & Web Services - UDDI v.3 Web Services Registry, new Oracle EBS and SQL LOB adapters, enhanced host system integration (MQ, IMS, DB2, CICS) & updated ESB Guidance. Developer &a......

70 of 1109 | Strange Service Window Behaviour - Thought I would add a quick post about some strange behaviour we have been monitoring recently with service windows.  Our situation was as follows: We have 4 ports which monitor FTP locations, 2 of them have service windows and 2 dont.  The service windows are specifically for a 1/2 period and have a 5 minute polling period in them.  Our servers are not configured for high availability because there are issues with being able to cluster the servers so we monitor the hosts using HP Openview and if they go down a manual intervention is used to initiate a host on the other server.  We receive 4 files per day one for each location. The symptoms we experience are as follows: The ports w......

71 of 1109 | Zend Framework 1.6: Dojo, SOAP, Testing, Tooling, and more - Andi Gutmans announced Zend Framework 1.6 which includes the new Dojo support which they put to work on the site itself: With this release we continue to provide enterprise-grade features with our new Zend_Soap component, which brings PHP-style simplicity to building and exposing SOAP web services. This component can operate in both WSDL and non-WSDL mode and makes creating or consuming a SOAP service a snap. Preview of Tooling Project: Zend_Tool is a component currently under development in the Zend Framework library. It provides services for generating and managing ZF-based projects. We are offering a preview release along with ZF 1.6 to collect feedback from users in a variety of env......

72 of 1109 | [DSL Tools] Support of Nested shapes in Visual Studio 2008 SP1 - As one of our customers remembered, we had announced a better support of nested shapes in Visual Studio 2008 SP1 / VSSDK 1.1. But it turns out that on the list of improvement we shipped with VSSDK 1.1, we only talked about the print preview, and not the nested shape feature. This post aims at answering what has changed, and why we did not advertise this feature too much. Since at least one person is wondering, it's worth reviewing the improvement: the improvement is, in fact, in the runtime of the DSL Tools. And this runtime, you might know it, is shipped with the Visual Studio 2008 SP1, not the VSSK. The part of the DSL Tools which is in the VSSDK covering what we call the "authoring exp......

73 of 1109 | Interview Series: Four Questions With … Alan Smith - Last month I started a new blog series where I interview a different “connected systems” thought leader each month and get some insight into their experiences and thinking in our space.  Our first victim/subject was Tomas Restrepo. We continue the series by chatting with everyone’s favorite Swedish BizTalker, Alan Smith. Q: You spend a healthy amount of time facilitating the MSDN BizTalk R2 forums. What are some common assumptions or misunderstandings about BizTalk Server that you frequently see questions about? A: There are quite a few people asking about using BizTalk for heavy database integration, taking flat files, inserting the data in databases and processing it. SQL Server Integra......

74 of 1109 | Webcast Replay: TFS and EPM Integration - My colleague, David Scruggs, recently did a MSDN Webcast on Integrating TFS and EPM. For those of you who are not with what EPM means from a Microsoft point of view, it stands for Enterprise Project Management and the related products associated with it are Project Professional, Project Server, and Project Portfolio Server. TFS does have some project management capabilities and native hooks into the Microsoft Project Professional, but for a Project Management Office (PMO) that uses Microsoft Project Server and/or Project Portfolio Server, using Project Professional is SOOOO last century. In the webcast, David covers TFS work item workflow, Project Server workflow, and how to use the TFS-PS......

75 of 1109 | Things are Pretty OK - I've been having an email discussion this weekend with some folks on the team about what "success" looks like for HealthVault ... kind of like those freshman-year-of-college things where you stay up all night and have pretentious debates about the impacts of Keynesian economics on individual property rights. I love a good email soapbox, as I am sure my long-suffering colleagues will confirm. But here's the thing ... philosophy aside, there is real, concrete evidence popping up all over the place that says -- we are really getting there with this HealthVault thing. And watching all that momentum leaves me feeling pretty peppy, so I thought I'd share a few cool items with you all: Hospita......

76 of 1109 | MySQL to SQLServer 2008 Express [redux] - Last week, the SQLServer 2008 Express team released a download with the SQL Server Management Studio. A few weeks ago, I blogged how to export/import the .sql from one system to another. Having installed the Management Studio, I noticed that I could import data into my new SQLServer database:   Having previously installed the MySQL .Net connector, all I had to do was fill in the blanks. Server (with remote access enabled), database, username and password. The tricky part is mapping MySQL datatypes to SQLServer datatypes, and importing. Note that with a non-Express version of SQL Server Management Studio, you can save the schemas and automate the import. Download it and give ......

77 of 1109 | [DSL Tools] Reference relationships and compartment shapes - Presentation of the problem: Deleting behaviour with compartments representing embeddings Most of the time, in the DSL Tools, you map compartments in compartment shapes to embedding relationships. And then, deleting a compartment item in the compartment shape indeed removes the model element which was displayed as this compartment item, which makes sense.   Deleting behaviour with compartments representing reference relationships Now let's suppose you have are mapping a compartment not to an embedding, but to a reference relationship. You might think that deleting a compartment item will only delete the link between the instance represented by the compartment shape and the instance r......

78 of 1109 | Behind the scenes at TechEd 2008 Australia - Prep Day 2 - I have had a unique insight into the setup of TechEd 2008 here in Sydney. I've been helping Breeze, one of Microsoft's integration specialist and training partners, in setting up RFID - a world first for TechEd.  Its an ambitious effort that belies the size of the team (Approximately 22 doors, 90 antennas and about 200 readers).  Since building the original prototype 2 years back watching this come together has been the realisation of an idea. Despite multiple challenges the team (Microsoft, Breeze and Kinetics) have come together with an area of technology that covers the spectrum of technology infrastructure, business productivity, application development and support. The day I ......

79 of 1109 | Just Published! WSS 3.0 and MOSS 2007 SDK 1.4 Download and Online MSDN Library - [Cross-posted from Randall Isenhour's blog.] Hello SharePoint Developers! We are excited to announce the availability of the latest updates to the online MSDN Library + the downloadable SDKs for both MOSS 2007 and WSS 3.0! In our never-ending efforts to improve the customer and partner experience, we are announcing the sim ship of both the online MSDN Library and the downloadable SDK! No more confusion about what’s the latest version: August is August! > Download the MOSS SDK 1.4 < > Download the WSS SDK 1.4 < The August 2008 update is version 1.4 and reflects feature enhancements that were part of the recent Infrastructure Update.  For more information on Share......

80 of 1109 | Tip Of The Day: Disable Software-enumerated Devices - If you run TAP.exe on your target hardware you will get every device listed in the registry. Some of these devices are not real devices at all, but are software-enumerated devices and are very rarely (if ever) needed on a runtime image. Disabling or deleting these software-enumerated devices will save on footprint because their dependencies unnecessary files will not be added to your image, and neither will the chain of dependencies for each of these devices. To get the benefit, you need to remove them from the configuration before you ever through the check dependency phase. You can do this in two ways: Manually remove them from your configuration in Target Designer Create a custom com......

81 of 1109 | Connected Systems Competition - I would be tempted to enter this contest, but my day-job seems to be taking up too much time :-S. I think that a SOAP receive adapter, for polling web services, would be a good bet for category #14? On the subject of the day-job, I obviously haven't posted for a while, and that's largely 'cos I'm so busy. I've spent the last month working at the commercial end of the business, spending 8 hours a...

82 of 1109 | Debatching Sql receive adapter resultsets - I spent Friday with a client advising them on some basic design principles, specifically around the use of the Sql receive adapter. It was a fairly simple scenario - extracting data from a SQL Server database, then processing the output messages with some very simple orchestrations. It seemed fairly obvious to me that the easiest way to process the data was to split the output from the receive ...

83 of 1109 | Delivery Notification Doesn't Appear with Specify Now Binding - Now, I don't pretend to understand this, so if someone can enlighten me, I would appreciate it :)I have a web port type defined in orchestration to a OneWay web service. When I create a port based on the web port type and I select Specify Now in the port configuration, then the Delivery Notification property doesn't appear. If I go into the port properties window and change the binding to Specify Later, the Delivery Notification property appears! Change the binding back, and it disappears again! Eh?My guess is that the delivery notification property is implicitly set when using the SOAP adapter (which is the default using a web port type and specifying the binding in the orchestration),......

84 of 1109 | One more thing - When using the Sql adapter to receive batches of data, a couple of handy hints: 1. Use a stored procedure. It allows you more control and security, and abstracts the underlying table structure. 2. Always add a parameter that allows you to restrict the size of the output (using SET ROWCOUNT). This allows you to control the flow of input messages - if there's a chance that your sproc is going to ...

85 of 1109 | Transactional Adapters and Adapter Base Classes - the BizTalk Adapter Development blog just published a whitepaper entitled "Developing a Transactional BizTalk Adapter Using the Microsoft Base Adapter Classes" you can download it from here. i think it is a must read for anyone serious about Biztalk server...

86 of 1109 | XML Explicit and SQL receive adapter - Following on from my theme of 'hacking' around the limitations of the various wizards / auto-generated artefacts in BizTalk, here's an excellent posting on how to consume xml produced from SQL Server using XML EXPLICIT rather than XML AUTO.10:22 AM 3/31/2005...

87 of 1109 | ASP.NET 2.0 CSS Friendly Control Adapters 1.0 -   "ASP.NET is a great technology for building web sites but it would be even better if it provided more flexibility for customizing the rendered HTML. For example, the Menu control makes it simple to add a menu to a web site, but it would be better if it didn't create <table> tags and was easier to style using CSS. Happily, it's easy to customize and adapt the Menu control to generate better HTML. Indeed, you can modify any ASP.NET control so it produces exactly the HTML you want....(read more)...

88 of 1109 | HTC announce the S740 Device - HTC today announced the S740 Windows Mobile device – this device is the next generation of CandyBar Smartphone from HTC.  It combines a 12 key keyboard with a full QWERTY keyboard that slides out. The device doesn’t have touch screen but it has a comprehensive specification: Processor Qualcomm® MSM7225™, 528MHz Platform Windows Mobile® 6.1 Standard Memory ROM: 256MB RAM: 256MB SDRAM Dimensions 116.3 mm (L) X 43.4 mm (W) X 16.3 mm (T) Weight 140g with battery Display 2.4 inch TFT-LCD with backlight LEDs and QVGA resolution Network HSDPA/WCDMA: 900/2100 MHz for Europe (Up to 384 kbps up-link and 7.2 Mbps download speeds) ......

89 of 1109 | HTTP Post adapter - I wrote my first two way adapter the other day. I have created it to communicate with Zirmed to send insurance verification request/responses via a HTTP Post. My question, however, is how often are people using this method of transport, and would anyone...(read more)...

90 of 1109 | Popfly: Build Cool Apps - No Code - Earlier this year Microsoft unveiled a new tool for building web mash-ups and games called "PopFly".  The alpha 1 version contained only the mash-up functionality and web page designer, but this past May saw the alpha 2 version with the game developer. Popfly is entirely browser-based, so there is no application download and no software installation on the local client.  To use Popfly, you go to http://www.popfly.com and sign in using a Windows Live ID.  If you don't have one, there is a link to create one.  Once you are logged in, you can create content and save it to your profile.  Once content is saved, you can share what you've made with friends by giving the......

91 of 1109 | ASP.NET Tips: DropDownList.ClearSelection() to avoid "Cannot have multiple items selected in DropDownList" - Problem I was facing the following Exception when I was programmatically assigning Selected Value of a DropDownList with the following piece of code. ListItem item = DropDownListTest.Items.FindByValue("Test");   if (item != null)      item.Selected = true; Exception Cannot have multiple items selected in a DropDownList. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Web.HttpException: Cannot have multiple items selected in a DropDownList. Source Error: An unhandled exception was generated during the e......

92 of 1109 | Module window not available - If you are debugging pipelines or adapters in BizTalk, you can't just 'debug' the said component in Visual Studio (however, there are rumors of that changing in v.Next), you have to deploy and run it in the service. You need to attach to the...(read more)...

93 of 1109 | Interesting Downloads for Week Ending 15-8-2008 - Hi All, Please find attached the listings of new or updated downloads for the week ending 15th August 2008.  Key ones include: Infrastructure Development & Operations • Microsoft Solution for Hosted Messaging and Collaboration 4.5 • Office Communications Server 2007 Best Practices Analyzer • Systems Management Server 2003 Inventory Tool for Dell Update • Windows Server 2008 Operating System Management Pack for Microsoft Operations Manager 2005 Solutions & Solution Development • Microsoft Visual Studio 2008 Service Pack 1 (Installer) • Visual Studio 2008 Service Pack Preparation Tool • Microsoft .NET Framework 3.5 Service Pack 1 • Microsoft Sync Framework v1.0 CTP1 ......

94 of 1109 | Making Sense of Server Roles - Our Guest Star series continues with Matt Parks, one of our first CRM MVPs and a key figure in the CRM community. One of the many things that was introduced with Dynamics CRM 4.0 is the concept of server roles.  Available only with the Enterprise license of Dynamics CRM, server roles provide quite a bit of flexibility is controlling what components of the solution run on each server in a multiple server deployment.  However, with flexibility comes confusion. With Dynamics CRM 3.0, the choice was quite simple when you had a multi-server deployment, there wasn’t one.  You installed the app on the first server and chose to create your new databases.  Then, on the ot......

95 of 1109 | More Information on UpdateGrams - In previous blog posts I have mentioned this large project that I am working on.  This project has been a great project for finding lots of material to blog about.  What I have not mentioned so far are the people that I am working with.  This project is a joint effort between Microsoft Consulting Services and Microsoft Global Services India (MGSI).  There have been great contributions by all of the off-shore team (unfortunately, far to many to list) and I would recommend them anytime as an off-shore group if you are looking to implement an off-shore model.  I have been very fortunate to be working closely with a small tight knit sub team.  This team is made......

96 of 1109 | New Volume License Rights - Application Server License Mobility - Just released, an important new Microsoft Volume License brief, “Application Server License Mobility”, has been posted to the Microsoft Volume License Briefs site, which describes new Microsoft Volume Licensing rights that enable server application licenses to move more freely across servers in a server farm, waiving a 90-day license reassignment rule. These new rights are effective as of September 1, 2008. To help customers take advantage of virtualization technologies, Microsoft is updating its software licensing policies for server applications (This change is for qualifying server applications, not desktop applications or the Windows Desktop O/S). This latest set of changes complement ......

97 of 1109 | SAP ADO – Design Time helper tool - Attached to this post is a standalone .NET Windows Form application which can be used to browse artifacts on SAP, and build queries which the SAP ADO.NET provider can understand. The main aim is to reduce the grunt work required when building the queries. The provider supports EXECuting RFCs, SELECTing from a single table, and SELECTing from two tables (JOIN). The tool I’ve attached currently supports EXECuting RFCs and SELECTing from a single table; support for generating queries which use a JOIN will be added in a later version. The current version of the tool is linked against the 32 bit version of CTP3 of the BizTalk Adapter Pack V2. I’ll update the attachment as and when newer versio......

98 of 1109 | La démocratisation de la performance de l'entreprise avec PerformancePoint Server 2007 - Un besoin grandissant / La donnée au centre des entreprises Le système d'information est devenu depuis quelques années un point central pour la croissance des entreprises. Dans un premier temps ces systèmes ont permis de collecter et de traiter l'information tout en optimisant son stockage. Puis dans un second temps, grâce à l'évolution de la puissance des machines, de la capacité disques grandissante, ces données ont pu être croisées et agrégées à des fins analytiques. Nous voyons aujourd'hui fleurir de nombreux projets autour des problématiques « VLDB » (Very Large Data Base). Le traitement de données de masse n'est plus une barrière au grand bénéfice des projets axés sur la Business In......

99 of 1109 | New SSIS community samples - Some new samples have been added to the SSIS community samples project on codeplex. Delimited Flat File Reader This data flow source component is capable of parsing delimited flat files, including files with rows that are missing columns. Package Generation Sample This standalone executable shows how to use the SSIS object model to do schema-based dynamic package generation. It works with SQL Server, Excel and Flat Files as source / destinations. Hello World Task Sample This is the sample that I previously blogged about. It’s a simple Hello World type task that shows how to extend the base task UI classes. SharePoint List Adapters This sample contains data flow source and d......

100 of 1109 | The OS400 MA only imports a subset of the available user profiles from an AS/400 - If you are using the OS400 Management Agent (MA) that is included in Host Access Management Agent (HAMA) to import user profiles from an AS/400, you may run into an issue where only a subset of the defined user profiles are imported. This problem can occur when the AS/400 user profile (aka user account) that the OS400 MA is using to connect to the AS/400 does not have all of the necessary permissions required to perform this function. The HAMA documentation states the following regarding required permissions for the OS400 MA: Requirements for the IBM AS/400 account used to run the IBM OS400 MA The user profile account on the IBM AS/400 host used by the IBM OS400 MA must have "*SECADM" p......