.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Anyone can share the code (or) the component - XML Destination Adapter

Posted By:      Posted Date: September 15, 2010    Points: 0   Category :Sql Server
Is there anyone, who can share me the Code (or) the component itself for XML Destination Adapter.  I have a requirement to create XML file as a destination from the source being 3 to 4 tables.  Request your quick response for this.  Thanks a lot.

View Complete Post

More Related Resource Links

How to install the Css Friendly Control Adapter Source Code


Hi guys really new to ASP.NET I was trying to install the CSS Friendly control adapter but for some reason the instructions on the website seems outdated. I downloaded all the files (Source Code, DLL, Browser) I believe I need to add the DLL file to my website's Bin folder and the Browser file to the APP_Browsers folder is this correct? After I place this files how to I get it working? what do I have to do?

Also if I want to create a new DLL file from the Source code how do I do these? I opened the web-site with Visual Studio 2008 and I can see all the files in the solution explorer? But how do I compile this to a DLL file? I tried doing a build solution but all I get is an .sln file???

Any help would be greatly appreciated

Thanks in advance


Share Code: Write Code Once For Both Mobile And Desktop Apps


If you're building .NET client apps already, target them to Windows Mobile using the same skills and toolsets.

Daniel Moth

MSDN Magazine July 2007

Toolbox: Code Generation, A Charting Component, and More


Developers have a number of tools at their disposal, but which of these components do you really need to complete your project? Each month we'll analyze the latest software and books to see if they merit inclusion in your toolbox.

Scott Mitchell

MSDN Magazine January 2006

how to send email in asp.net to any destination eg yahoo,gmail,hotmail etc c# code

hi i have try many code for sending email from msdn and many sites.but still i could do so. some code are here...   SmtpClient smtpClient = new SmtpClient();         MailMessage message = new MailMessage();           try         {             MailAddress fromAddress = new MailAddress(txtEmail.Text, txtName.Text);               // You can specify the host name or ipaddress of your server             // Default in IIS will be localhost              smtpClient.Host = "localhost";               //Default port will be 25             smtpClient.Port = 25;               //From address will be given as a MailAddress Object             message.From = fromAddress;               // To address collection of MailAddress             message.To.Add("admin1@yoursite.com");             message.Subject = "Feedback";               // CC

multiple services to same code destination

I've been using WCF for years and have been in the 90 of the 90-10 rule.  Now I need to start using WCF in ways that don't fit neatly.  I find it exciting, actually.  But it's a lot harder to find the information I need.  So I'm turning to this forum.  I have two fundamental questions: 1. In the config file under the "service" tag, is the "name" attribute like the "codebehind" value in an asp.net page?  i.e., does this always map to the code that is called? 2. Is it possible to specify two difference services with two different endpoints go to the same code location?  If so, how would that code be able to determine which service was called?  I know I could implement two different code destinations that call on the same reused code elsewhere but I may not have that option given the state of our legacy code.

.NET 3.5 SP1 failed with the error message - Error code 1603 for this component means Fatal error du

I had Beta version of VS 2008 and I wanted to install .NET 3.5 SP1. Installation led to some serious problems. I tried almost everything to install .NET 3.5SP1 (or VS 2008 SP1), nothing works

* VS 2008 has been uninstalled
* 3.5 uninstalled and cleaned
* 3.0 uninstalled and cleaned
* WF components removed
* document manager components removed

when I try to reinstall 3.5SP1, I keep receiving the following error in dd_dotnetfx35error

[01/11/09,00:23:05] XPSEPSC Installer: [2] Error code 1603 for this component means "Fatal error during installation.
[01/11/09,00:23:06] XPSEPSC Installer: [2] Setup Failed on component XPSEPSC Installer
[01/11/09,00:23:32] WapUI: [2] DepCheck indicates XPSEPSC Installer is not installed.

Then I check the contents of dd_dotnetfx35install for the event error log and found the following
[01/11/09,00:23:05] XPSEPSC Installer: ***ERRORLOG EVENT*** : Error code 1603 for this component means "Fatal error during installation.
[01/11/09,00:23:05] Setup.exe: AddGlobalCustomProperty
[01/11/09,00:23:06] XPSEPSC Installer: ***ERRORLOG EVENT*** : Setup Failed on component XPSEPSC Installer
[01/11/09,00:23:06] Setup.exe: GetGlobalCustomProperty - Property: {BBE1827C-F2FD-4FDA-A6D6-C83B62FFFDCA} - PropertyName: compfailed - Value: 0
[01/11/09,00:23:06] XPSEPSC Installer: CBa

Unable to connect with IBM DB2 using IBM DB2 .NET Data Provider 9.1.5 with ADO Destination Component


As we are passing through critical phase of the project and we are facing following issues which need to be resolved.Please help on this.

Currently we are transferring Data from SQL Server to DB2 using SSIS (SQL Server 2008).The IBM DB2 version is DB2 ESE 9.1 Fix Pack 5 on Linux 4.8.

1] Unable to connect with IBM DB2 using IBM DB2 .NET Data Provider 9.1.5 in SSIS 2008 at run time (although the connection is tested successfully with IBM DB2 using IBM DB2 .NET Data Provider 9.1.5 in SSIS 2008) and the error is

"[ADO NET Destination [6096]] Error: An exception has occurred during data insertion, the message returned from the provider is: Object reference not set to an instance of an object. "

I tried to use CozyRock DB2 Destination component instead of ADO destinatoin Component then i am able to use IBM DB2 .NET provider at run time.

Also i tested connection successfully using IBM DB2 .NET Data Provider 9.1.5

SSIS Custom Destination Component colum mapping issue


Hi ,

I am facing the below issue.

I am developed a custom destination component.I have custom UI also to set some properties.

Once i save the component and do the mapping in the Show Advance Editor Colum Mapping.This is working fine.

The problem starts Next.If I edit the component and do some changes  and say Ok ,In the output colum mapping all the mappings which i have already been set is getting removed.Then again i have to remap it.Ho to keep the existing mapping if we edit the component?

need help to solve this issue.

Bug when using SSIS OLE DB Destination Component using the IBM DB2 v9.# driver

I thought I woud pass on some helpful information with a problem we been experiencing writing to DB2.

It seems that the SSIS OLE DB destination component experiences problems using the IBM DB2 Driver during validation when writing to large DB2 tables ~ 4 million rows. Usually results in a "out of memory" error. We have open a case with Microsoft.  

Until this can be fixed there are several alternatives 
1. If you want to use the OLD DB Destination Component create a view on the Table and add a Where 1=2 so no records return 

2. Use the OLE DB Command component  .. Insert into table (col1,col2) values (?,?)  - this is actually 2 x faster

3. CozyRoc has a excellent DB2 Destination custom component that uses IBM Db2 driver bulk copy API it's 20x faster - very impressive! http://www.cozyroc.com/ssis/db2-destination

hope this helps..


Recordset Destination Component Error in SQL Agent


I am using the Recordset Destination Component to populate an Object Variable, and then using a For Each Component to loop over that Variable.  The package executes perfectly if I run it from within BIDS, however, when I execute as a Job Step within the SQL Server Agent, I get the following error:

Description: Component "component "Recordset Destination" (34)" could not be created and returned error code 0x80070005. Make sure that the component is registered correctly.  Code: 0xC0048021  Recordset Destination [34]     Description: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "Recordset Destination;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;0"  Code: 0xC0047017

I have tried executing in the Job Step every way I can think of...as command line from file system, from within SQL Server, as 32-bit, 64-bit, Windows Auth, SQL Server Auth...

Any Ideas?



Microsoft Visual Studio 2005
Version 8.0.50727.42  (RTM.050727-4200)
Microsoft .NET Framework
Version 2.0.50727 SP1

Installed Edition: IDE Standard

how to Selec site Tempalte Picker using Code in Share point 2007


Hi Guys,

My Requirement is: I have an page it's coming from _Layouts,that page contains one Template Picker Control(share point control).so it showing all site templates like Team site,Wiki site etc.

But My Issue is i have site template id like "STS#1" Now i need to show  this site template in  Template Picker Control using c# or Object model code.how to do that right know it selected  Default site template.

Thanks In Advance.

Murali krishna.T


Overriding Existing Custom Destination Component


Hello Guys,

We have the following requirement.

We need to create a custom component, which will be put in our existing ETL Packages. This component will call the Rules engine and will send the data to the destination. I want something which can override the Existing OLEDB Destination component. i.e. a container control which will call Rules engine + the custom destination component.

The idea is that i will need to modify the existing ETL Packages. The only change i need to do is to replace the OLEDB destination component will this Custom Component and no other change should be required.

Can you please suggest, which is the best approach and any articles or code for direction.


SSIS pakage fails "component "OLE DB Destination" (67)" failed validation and returned validation st


I have a package that is executed within a SQL job. The package has been running successfully since quite some time now. Recently I had to rebuild the DB schema (as I was testing the deployment of my application). The package ran successfully once after I re-built the underlying DB  schema.  But it  failed with the following message the next day but has been running successfully automagically after it had failed. 

Note : The schema before and after the rebuild operation has not changed.

The error message thrown on the day it failed is as below (loginname/tablename/Task name are scrubbed) :

Executed as user: <User Name>. Microsoft (R) SQL Server Execute Package Utility  Version 10.0.2531.0 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  7:00:00 AM  Error: 2010-11-13 07:00:10.03     Code: 0xC0202009     Source: <Task Name> OLE DB Destination [67]     Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.  An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80004005  Description: "Connection is busy with

Component with name "sql server destination" and class ID {} could not be created because it was bui


Hi using VS2005 with sql2005 I get the above error message for all my package sql server destination objects. I also have vs2008 installed on my machine and am wondering whether this is causing this error. Either way, any idea for a solution?

Using the connection manager I have set up an ole db/sql connection that tests successfully.

Many thanks,


Adapter Design Pattern in C#, VB.NET

Convert the interface of a class into another interface clients expect. Adapter lets classes work together that couldn't otherwise because of incompatible interfaces.

Code Optimized Web Development Profile (VS 2010 and .NET 4.0 Series)

When you first run VS 2010 it prompts you to select an IDE profile to use. The profile you select will configure how tool windows are displayed/docked in the IDE by default and set the default keyboard shortcuts. You can then customize any of these settings by using the Tools->Options menu within the IDE and then override/change them. You can also later reset your profile and pick a different one by choosing the Tools->Import and Export Settings menu command.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend