.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

OLEDB Source Problem?

Posted By:      Posted Date: August 29, 2010    Points: 0   Category :Sql Server
Hi all, My source is oracle am loading the based on process date. I took one variable. Changed evaluate as expression=true. In expression I wrote below query. My total records 696148.only 695590 are loaded in my staging table. After 30 min also its showing yellow color with same records. I changed my process date. Same thing happened. What is the problem I didn’t find? "select member_number,tran_id,tran_dt,store_no,tran_line_id,tier_id, disc_prog_id,disc_prog_lev_id,sku_no,coupon_amt,total_qty,total_price_amt, earned_amt,stmt_amt,paid_dt,sales_stmt_status_code,process_date, orig_tran_id,stmt_num,discount_amt,master_number,order_channel_cd, category,tran_type  from sales_stmt_detail  where to_char(process_date,'MM/DD/YYYY') =" + "'" + @[User::V_SQLProcessDate] +"'" Thanks cmk..

View Complete Post

More Related Resource Links

Problem getting applicaton to run after retrieving it from source control software.


I am restoring my asp 2.0 app from a source control project to my local drive.

The application was originally created on a different PC but was created with Visual Studio 2005,

ASP.net 2.0.

The source control add-in (Harvest) is not working correctly so I retrieving and saving my web app

outside of Visual Studio.

I finally put all the pieces of the web app back together but now when I compile my app I get the following message:

Build (web): Could not load the assembly 'App_Web_myApplication.master.cdcab7d2'. Make sure that it is compiled before accessing the page.

Will I have to start over ?

Thanks for your insights !

SSIS And Sybase Source OLEDB connectivity issue with code page for character set

Hi I am using SSIS 2008 to connect the Sybase Server version 15.0.3 64-bit. The default character set id used by this Sybase server is 4 (i.e. roman8). (http://manuals.sybase.com/onlinebooks/group-charc/chg0300e/charsets/@Generic__BookTextView/1706;pt=266) I had installed Sybase Client for Sybase OLEDB Driver (ASEOLEDB) to integrate this in OLEDB Source Editor. As per guidance from one of the past MSDN forum discussion, I tried setting property of AlwaysUseDefaultCodePage property to "FALSE"  (http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/f5af9328-e1fb-48d7-a85d-1d08bb7cf0e5/). However, I am still experiencing error message as follows:- ********************************************************* Error at Package2 [Connection manager "xxxxxx.xxxxxxx"]: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available.  Source: "ASEOLEDB"  Hresult: 0x80004005  Description: "[00000] [Native Code: 30061] [ASEOLEDB]Could not load code page for requested charset". An OLE DB record is available.  Source: "ASEOLEDB"  Hresult: 0x80004005  Description: "[1ZZ001] [Native Code: 30016] [ASEOLEDB]Internal Error". Error at Data Flow Task 2 [OLE DB Source [1]]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMC

Refer Rows/values of OLEDB Source inside DFT

I have a Data Flow task that implement Insert/Update using logic:  http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/131dbe38-95a9-4b64-8434-60ba3cd6de00/. Now I want to also include "Delete" just after the OLEDB Source where I will delete from Target Table if the Rows are present in Target and No in the OLEDB Source. So what control I should use and how do I refer to the OLEDB Source records. May be something like: Delete from dest_table where ID NOT IN (SELECT ID from OLEDBSourceControlRecords)... Thanks, Prabhat

OLEDB Source running full MDX query when validating




I have an Integration Services project which creates a flat file report from Analysis Services, I'm using an OLE DB as data source and running an Openquery in the SQL statement.


the problem is that Integration services runs the query twice before getting the data into the flat file. I know this because the query runs two times in Profiler, and because the same query takes half the time when run in Management Studio.


Integration Services is running the whole query when validating. how can I disable this validation or better make it validate properly.



Add parameter to ADO or OLEDB Source without using Expressions?


(Using BIDS 2008 R2)

Is there any way to add parameters to a ADO or OLEDB Source without using Expressions? Just like Execute SQL Task (Control flow) and OLE DB Command (Data flow)

I find it very cumbersome to have to go and change the expression. If I add a column, then I also need to go back to the Source query, add and remove a space before it adds the column to the output. Also sometimes I forget that I have an expression and when I save the package the Expression overrides the query I had just updated in the source.

Hope someone can help.



How to make up MDX with parameters of SSIS OLEDB data source

Hi everyone,

I want to make up a MDX query by using some parameters, just like:

{...}ON ROWS
FROM [CubeName]

I put this query in the 'sql command' field of OLEDB data source, and replaced the date parts with parameter token '?':

{...}ON ROWS
FROM [CubeName]

However, when I clicked 'parameter' button, the exception below showed:

Parameters cannot be extracted from the SQL command. The provider might not help to parse parameter information from the command. In that case, use the "SQL command from variable" access mode, in which the entire SQL command is stored in a variable. (Microsoft Visual Studio)
Error Code = 0x80040E51, External Code = 0x00000000:. (Microsoft OLE DB Provider for Analysis Services 2008.)


Custom Data Source Problem


I created a data model in BIDS, built a report from the data model in Report Builder 1.0, and saved to our report server.
When I run the report from the Report Manager it runs fine.

I am trying to modify the report for Data Driven Subscription.
When I setup a Custom Data Source and enter the same credentials that work fine in the Shared Data Source,
I get a very strange error:

An error occurred during client rendering.
An error has occurred during report processing.
Query execution failed for dataset 'dataSet'.
Incorrect syntax near '<'. The label 'xmlns' has already been declared. Label names must be unique within a query batch or stored procedure. The label 'xmlns' has already been declared. Label names must be unique within a query batch or stored procedure. The label 'xmlns' has already been declared. Label names must be unique within a query batch or stored procedure. The floating point value '6e2909' is out of the range of computer representation (8 bytes). The floating point value '6e2909' is out of the range of computer representation (8 bytes). The floating point value '22e84222201' is out of the range of computer representation (8 bytes). The floating point value '6e2909' is out of the range of computer representation (8 bytes). The label 'xsi' has already been declared. Label names must be unique within a quer

How to create a source component using Oracle oledb connection


How to create a source component using Oracle oledb connection in x64??


problem with sql data source - view with INNER JOIN



I have a question. I created a new data source (sql database connection) - a view that contains INNER JOIN statement. After that I created a page and put Edit Item Form on it based on this data source. When I open a page and try to update some records I get an error: "The data source control failed to execute the update command."

There is no error when I use a view without INNER JOIN...

Can I solve it? Should I write my own UPDATE statement?

Thank you.

Execution SSIS package in .NET: ADO NET Source with Expressions Problem

Hello Gurus!

We try to execute our SSIS packages from a .NET application. It works fine until we use “Expressions ” inside Data Flow’s components like “ADO NET Source” (e.g., for building SQL statements)

I use the ADO NET Source Control and want to set the SqlCommand property with an expression holding a SQL statement.

When executing the SSIS package in Visual Studio (in debug mode) I get no problem, everything works fine. When executing the package from within my .NET application it crashes the app completely, only creating a generic Win32 Exception with no relevant information.

My steps:

1.       I created new SSIS package.

2.       Then added the Data Flow component.

3.       Inside Data Flow I added “ADO NET Source&

OLEDB source task + NULL Parameter



we are using SSIS 2005 and Sql server 2005. My stored proc has 3 parameter. 2 date parameters and 1 varchar parameter. The varchar parameter is set to null as default like this:

Alter procedure uspSPName







Incremental Load and the source archiving problem



I will appreciate your feedback on the following challenge:


  • A SQL Server transactional source system is being replicated to a shadow copy
  • Triggers were added on tables in the shadow copy to populate a Log Table with actions and timestamps (Added , Deleted , Updated)
  • The Log table is used for ETL to populate an Oracle DWH
  • The source system data will be archived and all rows is all tables will be deleted prior to certain date.
  • The archived data is still required to be maintained in the Oracle DWH
  • The replication between the source and shadow will populate the log table with lots of delete actions on data that in the DWH
  • The data in the DWH will be lost

How can we maintain the data in the DWH and prevent the data from being lost after the archiving ?

Essam Salah

Source file problem


My source safe asp.net c# file shows like each line with the box and Chinese language characters. 


using System;?????? ?????????????

What is my problem, Its may settings problem or hacking...?

Plz help me....

Microsoft OLEDB Provider for DB2 problem


I have an SSIS package that uses the Microsoft OLEDB Provider for DB2.

The connection to the DB2 machine works 100%, but when I try run a query I get the follwing error

An internal network library error has occurred. A network level syntax error has occurred. SQLSTATE: HY000, SQLCODE: -379 

The query parses fine but can't seem to run

Thanks in advance!

How to capture bad records from OLEDB source in SSIS?


Hi All,

My source and destinations are Sqlserver.I need to create nearly 40 packages with different table .Some time we will get bad records from source. How to capture the bad records? If I use redirect option in oledb destination  I need to create for every table one more error table also is it good or not How to handle this situation?





SSAS with Teradata Oledb data source



    I am getting this error while creating a data source view(for creating a cube)  from Teradata.As you can see from the message,I am using Oledb Provider for Teradata.

  'TDOLEDB.1' failed with no error message available, result code: DB_E_ERRORSOCCURRED(0x80040E21). (Microsoft Visual Studio)

Can someone help me, I have searched online for answers but could not find the solution.





Linked Server using Microsoft.Jet.OLEDB.4.0 problem


Hi all,

I'm using following code to create linked server and then access data

EXEC sp_addlinkedserver N'XLS',

'Jet 4.0',




'Excel 5.0;'

EXEC sp_addlinkedsrvlogin N'XLS', FALSE, NULL, Admin, NULL


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