.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

OLE DB Command in DFT is executing sp_execute for each row?

Posted By:      Posted Date: August 30, 2010    Points: 0   Category :Sql Server
HI All, The larger issue i am tackling is how to identify/update changed FACT table rows from incoming rows. I have gone through a lot of samples, Project REAL examples etc...the conclusion i came to was to use a Lookup transform and use the OLE DB Command task to issue updates. Is this the right way to go? Now specifically, when i do that, the DFT is taking an extremely long time to run through 250k rows. When i ran Profiler, i am seeing that the OLE DB Command is issuing an sp_execute for each row! I would like to hear what i am doing wrong with my overall approach and specifically for this OLE DB Command? Thanks!

View Complete Post

More Related Resource Links

Executing Command Logic in a View Model

Through the use of the Windows Presentation Foundation's (WPF) advanced data-binding capabilities, the logical structure of a user interface can relatively easily be disconnected from its presentation. Bindable components can now contain nearly all of an application's user interface logic and in most circumstances, replace the need for controller objects from the classic Model-View-Controller (MVC) pattern. So it's no wonder that a new pattern for UI design has appeared

Solution deployment requires executing execadmsvcjobs command on search server to complete deploymen

We have multiple Sharepoint 2007 farms and deploy custom code weekly to the farms. On one o the farms it is required to run stsadm -o execadmsvcjobs on the Search server in the farm in order for solution deployments to complete deploying. These are solution recycles that we are running. This is the only farm this happens on and all farms are identical. In central admin it shows the solution state as deploying. Farm Config Sharepoint 2007 SP2 w Dec Cumulative updates 1 WFE 1 Search server 1 SQL server

Maintenace Plan not executing properly from command line.

I am running SQL 2005 Standard SP3 on Microsoft Windows NT 5.2 (3790) This is a two node active/active cluster. I had a maintenance plan that was called from the command line by a third party scheduler (Tidal) and everything ran fine.  Then a new copy of the maintenance plan was created with additional code and named with _new at the end.  The new plan ran fine interactively (right click and execute).  The old plan was renamed to _old and the new plan renamed to remove the _new.  The scheduler will no longer run the maintenance plan.  I have attempted to run the plan manually from the command line, as the scheduler would do.  It finds the plan, says its starting and then runs for 6 seconds (should be about 50 minutes) and says it completed successfully, but obviously did not.  The history of the plan does not show any execution.  I have tried exporting the plan, dropping it and reimportng (jiggling the handle), I have also exported he old plan and dropped it, thinking there might be some internal name glitch.  I have no idea what is going on, but need to get the plan to run from the command line--forgetting the scheduler for the moment, the manual run from the command line does not work.  (I'll worry about the scheduler later).  The command that is being run is: dtexec /SQL “Maintenance Plans\ProvDUpeCln_CKN

An error occurred while executing the command definition. See the inner exception for details.



In my mvc asp.net application, I am getting error in edit function : in given code

public ActionResult Edit(int id)

var res = (from r in objeEntities.DocumentationsSet.Include("DocStatus")
where r.textid == id select r)

I am getting this exception:

  • Source : System.Data.Entity

    Stack Trace : at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) at System.Data.Objects.Internal.ObjectQueryExecutionPlan.Ex

Row command working on all rows not selected one?



I have this code that hides a column in a gridview.  (The column houses another nested gridview).

    Protected Sub GridView1_RowCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs) Handles GridView1.RowCommand
        If e.CommandName = "Select" Then
            If GridView1.Columns(0).Visible = False Then
                GridView1.Columns(0).Visible = True
                GridView1.Columns(0).Visible = False
            End If
        End If
    End Sub

The trouble is that if I click the select link on one row that action to hide is carried out on all rows.  How can I set this up so that it only hides the row that is selected?


Print command



Is there a way of setting up a print area for a part of my webpage, I only want to print a certain part of the page, when I select print at the moment it will print the whole page and the layout is rubbish!!

command object error


Could someone please tell me what is wrong with my syntax here?  I'd be much appreciative.


objCmd = New SQLCommand("SELECT CASE WHEN objDR('Item') = 'Enter Bill of Lading' then enterbol " _  

& "WHEN objDR('Item') = 'Bill of Lading History' THEN bolhistory " _  

& "WHEN objDR('Item') = 'Request Transfer' or objDR('Item') = 'View Transfer in Progress' THEN transfers " _  

& "END  from plantGroups where plantgroupid=@plantgroupid", objConn)

On page loading or executing all CSS flags are ignored and website is plain without formatting


 My problem is whenever i execute my app the first page that loads is the login page pointed to by my web.config file forms authentication, this page is meant to show CSS formatting for the info i am displaying but it is not. Any help with this problem would be great. A cut and paste of my problem is shown below as you can see there is no CSS.

jsfdnjldfngjfg here it is

Account Login
User Id:
Forgot Password?

I have inserted all the link as in:




Design Patterns: Simplify Distributed System Design Using the Command Pattern, MSMQ, and .NET


Service-oriented architecture is a great framework when you need to perform distributed computing tasks over the Internet. But when you want to perform processing inside your local network, a different solution may provide a better fit. That solution, based on the Command pattern, uses Windows services and Microsoft Message Queuing to implement a queued system that meets your needs better than a service-oriented solution. This article explains how to build it.

Brad King

MSDN Magazine September 2004

Command Management: Use Design Patterns to Simplify the Relationship Between Menus and Form Elements


In Windows Forms applications, similar commands, such as those in a menu and their counterparts on a toolbar, are not automatically related. They don't fire the same event or run the same handler routine. Yet code that allows the same or similar user commands to fire the same code simplifies development.This article describes the principles of command management and why it's important to have functional commands that are not exclusive to any one UI element. In order to provide an MFC-like command management infrastructure, a design pattern is developed and applied as a series of C# classes.

Michael Foster and Gilberto Araya

MSDN Magazine October 2002

Item cannot be found.(rsItemNotFound) when executing a report from a sharepoint Website

I have managed to integrate Report server with Sharepoint .
I created a report with it's data connection with microsoft Visual Studio 2005 , tested it , than deployed it to the specified document libraries in sharepoint.
Everything works fine till now.But when i try to execute the report from the document library in sharepoint the Message :
  • The item 'Reports/Report1.rdl' cannot be found. (rsItemNotFound) '. Even though the report1.rdl is inside the website and is returned when i do the search. Regards.

  • Using the BDC API how to catch the returned code when executing a stored procedure?

    using BDC API, how can i catch the return code a stored procedure returns?

    I tried Entity.Execute to execute a generic method. However, it returns an empty Entity table.

    I know you can do it by setting up an output variable. I prefer returning an integer for tracking errors.

    Any ideas?



    stsadm Import command + include user security



    When I move sites from test to staging to production, I am using the stsadm –o export command with the –includeusersecurity option in the staging environment.  In production environment, I then use the stsadm –o import command with the –includeusersecurity option.  I was assuming that this option was bringing over the security on the exported site only.  This does not seem to be the case.

    Last night I exported one sub site to produtction.  Today, I was notified that the security groups on other sub sites have been altered.  


    So why is it when using the –includeusersecurity option effect all sub sites and not just the one sub site being moved from staging to production

    Video: SharePoint 2010: Executing Code in the Sandbox

    Find out how the Sandboxed Solutions Service provides for a complete isolation system that ensures code running in a sandboxed solution cannot reach out to access information beyond the scope of the deployment. (Length: 12:01)

    There is already an open DataReader associated with this Command which must be closed first.


    when i insert record

    There is already an open DataReader associated with this Command which must be closed first.

    help me.

    SqlConnection conn = new SqlConnection(@"Data Source=Localhost\SQLEXPRESS;Initial Catalog=StudentDetails;Integrated Security=True");

    SqlCommand cmd2 = new SqlCommand();
    SqlCommand cmd1 = new SqlCommand();

    if (conn.State == ConnectionState.Closed)

    cmd2 = new SqlCommand("Select * from UserInfo where Standard", conn);
                SqlDataReader dr1 = cmd2.ExecuteReader();
                string stu, par,std,sec,roll;
                par = "";
                stu = "";
                std = "";

    Query Command to Report


    I would like to generate a crystal report showing the report data based on my custom SQL query.

    Where I can provide my SQL query or stored procedure.

    Please give me good tutorial links on this too.

    Thanks in advance.

    Case statement is never executing


    Can some please advise as to why the case statement is never running


    Imports Microsoft.VisualBasic
    Imports AjaxControlToolkit
    Public Class MultilevelAccordion
        Inherits System.Web.UI.UserControl
        Implements System.Web.UI.ITemplate
        Dim templateType As AccordionItemType
        Sub New(ByVal type As AccordionItemType)
            templateType = type
        End Sub
        Sub New()
        End Sub
        Public Sub InstantiateIn(ByVal container As System.Web.UI.Control) _
              Implements System.Web.UI.ITemplate.InstantiateIn
            Dim ph As New PlaceHolder()
            Select Case (templateType)
                Case AccordionItemType.Header
                    Dim myLabel As Label = New Label()
                    myLabel.ID = "HeaderLabel"
                    AddHandler ph.DataBinding, New EventHandler(AddressOf Item_DataBinding)
                Case AccordionItemType.Content
                    AddHandler ph.DataBinding, New EventHandler(AddressOf Item_DataBinding)
            End Select
        End Sub
        Shared Sub Item_DataBinding(ByVal sender As Object, ByVal e As AccordionItemEventArgs)
            Dim ph As PlaceHolder = CType(sender, PlaceHolder)
            Dim headerValue As String = _
    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