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

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

Bad performance in OLEDB destination (native SQL) when created in BIDS.

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :

Hi Guys,

When I create a package that loads data from oracle 11g to SQL Server 2008 R2 X64 by using the wizard it performs perfectly.

I then try to change the package in bids to use my shared data sources. no problem when changing source connection. But when i try to change the destination OLEDB then it starts to perform very badly.

I have tried running it with the from wizard defined destinationOLEDB and after changed in BIDS, there is a huge difference in performance.

Any idea why this happens?

I have even removed 64bit mode in debugging.

Best Regards



View Complete Post

More Related Resource Links

SharePoint List Source and Destination BIDS adapters not working for our sharepoint instance

It was with great anticipation I installed the SharePoint List Source and Destination BIDS adapters (from CodePlex, http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652). Unfortunately, the adapters are not working for our MOSS sharepoint instance.  We're a DOD (department of defense) site, so the level of security may be higher than normal and may be affecting the adapters. The error message was lengthy and I couldn't copy it and paste here.  I did screen shots and put the complete error message at http://www.christianbahnsen.com/sharepoint_source_error_message.pdf If I can get this to work I think it would be very useful.  I'd played around with KPI Lists, but one cannot create an Indicator directly from SQL Server 2008 (cf. my related thread at http://social.msdn.microsoft.com/Forums/en/sharepointbi/thread/bcc95f65-012e-4b8a-8850-b03fb0f16b0f).  I was hoping that these adapters would provide a work-around by populating sharepoint lists that could be the source for KPI Indicators. As always, thanks in advance for any assistance. Christian Bahnsen

OLEDB/ADO Destionation - Add input column twice to destination columns or static data


(Using BIDS 2008 R2)

OLEDB/ADO Destionation

Reuse input column
Is there any way to map a input column to two destination columns?

State static value instead of mapping column
I have a package for each version of the production system - they insert in the same destination tables - I just need to add a version number to the version column - like '2.1' and '3.0'. The only way I have found so far is to select a fake column in the source like select '2.2' as Version, ..- This is however not very smart when I'm selecting millions of rows.

I would just like to be able to type in a static value instead of mapping a column - any way to do this?

Training on Performance Point 2010 and SQL Server 2008 BIDS



Me and my team are developing a POC in Performance Point 2010 using SSASCubes,we are planning to recommend trainign for the team  but i had a couple of questions.

1.The Team is totally new to this technology as we dont know what is .NET,MOSS 2007 and SQL Server 2008 R2.

2.Does working in PPS 2010 requires basics of Sharepoint 2010 and .NET,if yes then what are the areas we need to look into it before proceeding with PPS 2010 training


Can anybody kindly guide us with the same




SSRS Report Sorting issue in Dashboard created usign Performance point services in sharepoint 2010


I have created a report in SSRS and this report is integrated within a dashboard created using performance point services in sharepoint 2010.

The report is a simple tabular report with 5 coulmns and interactive sorting is enabled on each of them.

Sorting works when the report is viewed separately but gives "Report Server Error" when I try to sort (on any column) inside the dashboard.

I have user IP instead of host name in the report server url.

Please help.



Cube Browsing in Performance Point 2010 as in SSAS and BIDS cube browser


Hi All,

Can we get the cube browsing experience as we get in SSAS and BIDS cube browser in SharePoint 2010 using performance point or excel services?

I am most interested in drag and drop features for dimensions and mesures.

More or less same browsing features were available in BIP viewer webpart but it is no more available.

So is there anyway we can drag and drop dimension members and measures in performance point dashboards?


Cube Browsing in Performance Point 2010 as in SSAS and BIDS cube browser


Hi All,

Can we get the cube browsing experience as we get in SSAS and BIDS cube browser in SharePoint 2010 using performance point or excel services?

I am most interested in drag and drop features for dimensions and mesures.

More or less same browsing features were available in BIP viewer webpart but it is no more available.

So is there anyway we can drag and drop dimension members and measures in performance point dashboards?


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,


Loading System::ContainerStartTime into an OLEDB destination


This is driving me crazy.  I want to load the system variable, System::ContainerStartTime, into a datetime column in SQL Server table via a SQL Command task.  When I do the parameter mapping, I have the following choices for data type (that seem valid to me):


When I use DBTIMESTAMP, I get invalid format errors in SSIS.  I think this is an OLEDB driver issue because I was profiling the database and did not even see the insert statement sent down to the server.

When I use VARCHAR, it loads in 1900-01-01.

When I use any of the other ones, it tells me that the datatype isn't supported.

What do I have to do in order to load this thing into a datetime column?

Windows 7 SP1 x86, ODBC, and SQL Native Client Performance


Good Morning Everyone,

**Reposting to SQL Board. I have this question with Windows 7 Performance as well.**

Since applying SP1 to select Windows 7 Ent machines (testing before mass install), I have found that one of our applications that uses the SQL Native Client for an ODBC connection is awfully slow. It takes 5 minutes for the application to load and come back with initial data load/presentation. I have tried every other SQLCLI install available, including 2005, 2008, and 2008 R2. This was the case when I first tested the application with Windows 7 about 6 months ago until I found driver version 2007.100.2531.0 SQL Server Native Client 10.0, which seemed to resolve the slowness issue. Now, after applying SP1, it has reverted in being slow.

Is there anything I can look for or modify that might be causing this issue? What part of SP1 touched the ODBC or SQL driver?




SSIS 2008 - Question on OLEDB Destination to SQL Server 2000

Simple question, In a SSIS 2008 Package is it possible to have a OLE DB Destination pointing to another Server Machine running on SQL Server 2000 to do bulk insert operation ? . what are the potential pitfalls when while inserting into SQL Server 2000 ?

ASP.NET Best Practices for High Performance Applications

This article lists the techniques that you can use to maximize the performance of your ASP.NET applications. It provides common issues, design guidelines, and coding tips to build optimal and robust solutions.

Top .NET Performance Problems and how to avoid them

Every time I work with one of our .NET customers to help them with managing their application performance I come across the same problems as seen with other clients before: lots of ADO.NET queries, many hidden exceptions in core or 3rd party .NET libraries, slow 3rd party components, inefficient custom code

High-Performance .NET Application Development & Architecture

It has always been a goal of project architects to plan an effective strategy from the ground up in regards to an new application. All relevant factors are taken into consideration with respect to the application, from its design and layout to a functional website infrastructure. Pre-.NET strategies and design guidelines still effective now were developed with Microsoft's DNA (Distributed interNet Application) platform. This model successfully served the purpose of architecting N(any number of)-Tier (levels) applications. In its basic sense, as in most robust, distributed applications, you'll architect 3 main layers or Tiers: presentation, business rules and data access.

How to improve the performance of ASP.NET MVC web applications

It is an in depth analysis of a Digg-like site and how it went from serving (on a test machine) 6 req/sec to 390 req/sec.

The biggest gain, 74 req/sec to 390 req/sec happened when he introduced data caching and another 25 req/sec where gained when he introduced the compilation of LINQ queries.

High Performance ASP.NET - Speeding Up ASP.NET Pages

have been writing a series of blog posts, which I have named High Performance ASP.NET Websites Made Easy! There is no rhyme or reason to the order of these posts and certainly can be read in any order:

Developing High Performance and Scalable ASP.NET Websites
Avoid Chatty Interfaces Between the Tiers in Your ASP.NET Web Application
ASP.NET Page Profiling - Page Tracing - High Performance and Scalable ASP.NET Websites Made Easy
Web Applications: N-Tier vs. N-Layer - Benefits and Trade-Offs
Query Analyzer - Sql Server Database Indexes and Execution Plans

Improving Application Performance in .Net

Application performance has always been a concern for Web Application developers. This article contains guidelines and tips for maximizing application performance in ASP.NET.

Tips to Improve Your ASP.NET Web site performance

ASP.NET has been developed with lots of features which makes developer life easy. Start from ViewState, PostBack, Server Controls , User Controls and etc. All of them can make your web development experience fun and easy, but improper use of them can cause your site performance slowdown. Most of the controls generate overhead to the client and server. Therefore in this article, I I will list out about things you can do and don't to improve your ASP.NET website performance.
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