.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

Adding Oracle table into SSIS project --Oracle error occurred, but error message could not be retrie

Posted By:      Posted Date: September 16, 2010    Points: 0   Category :Sql Server
Hi all I am new to design SSIS packages,to day I stated creating package SSIS package and adding the Tables,while adding tables,one of the table giving an below error . I verified the table structure it has one "CLOB" datatype. can some body help how to add this table( whole idea of the package is I have Dump those tables with structure and Data to SQL Server 2008 Database)  =================================== Oracle error occurred, but error message could not be retrieved from Oracle. Data type is not supported. (Microsoft Visual Studio) ------------------------------ Program Location: at System.Data.OleDb.OleDbCommand.ProcessResults(OleDbHResult hr) at System.Data.OleDb.OleDbCommand.PrepareCommandText(Int32 expectedExecutionCount) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.OleDb.OleDbCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.DataWarehouse.Design.DataSourceConnection.FillDataSet(DataSet dataSet, String schemaName, String tableName, String tableType) at Microsoft.AnalysisServices.Design.DataSourceDesigner.AddRemoveObjectsFromDSV() Thanks in Advance.   SNIVAS

View Complete Post

More Related Resource Links

Error Message: The referenced table must have a primary or candidate key. [ FK Name = FK_tblA_tblB ]

An Entity Data Model is used to generate the script to create  a SQL CE database.  It creates all of the 10+ tables and their primary keys without any problem. A lot of foreign key creations generate errors like the following: SQL Execution Error. Executed SQL statement ALTER TABLE [tblA] ADD CONSTRAINT [FK_tblA_tblB] FOREIGN KEY([A], [B], [C]) REFERENCES [tblB]([A], [BBB], [C]) Error Source: SQL Server Compact ADO.NET Data Provider Error Message: The referenced table must have a primary or candidate key. [ FK Name = FK_tblA_tblB ] The primary keys are there and correct. Could anyone offer some tips on how to figure out what is wrong?hz

Workflow "Error Occurred" Message

Hi, We have upgraded a VS 2008 custom workflow in our production environment but we are now seeing an "Error Occurred" message when starting in one site that the workflow is activated on.  It works fine on another site.  Permissions DID NOT change for users on this site before or after or during the upgrade of the workflow. It works fine in our test environment. How can I troubleshoot this in production environment (I cannot debug)? Can somebody give me a definite answer on what are the required permissions to give user to allow them to start workflows and edit only their own Tasks?  I have asked this question on a number of forums with no definitive answer.

Error: 0xC002F304 at FTP Task, FTP Task: An error occurred with the following error message: "Object

Hi All, I'm trying the FTP Task, I configure it as follow The FTP connection manager is ftp.microsoft.com The port is 21 The credentials anonymous Retries 5 and the chunk one The time out 60 I tested the connection and I does very well     In General section I set the FTPConnection to the connection manager In the File Transfer section IsLocalVariable is set to true And I defined an FTP varriable scope that holds the path to c:\temp\FTPDestination  I set the OverrideFileAtDest to true I set the Operation to recieve files  I set IsRemoteVariable to false I set Remote path to / The task seems to be well configured  but this runtime error raises once the package is fired Error: 0xC002F304 at FTP Task, FTP Task: An error occurred with the following error message: "Object reference not set to an instance of an object." So what can I do to deal with this situation? Thank you The complexity resides in the simplicity

Adding new page to WPF project causes key error.

I'm adding a second page to my project in a sub folder and I get the following compile time error: Error    1    Unknown build error, 'An item with the same key has already been added.'     WinTools  

Adding New Error Message to Validation Summary Control



 In the code behind based on a condition i want to add a error message to the Validation Control.

 I tried the below.

 'Call function to add error message.
protected void AddErrorToValidationSummary(string errorMessage)
 CustomValidator custVal = new CustomValidator();   
 custVal.IsValid = false;   
 custVal.ErrorMessage = errorMessage;  
 custVal.EnableClientScript = false;   
 custVal.Display = ValidatorDisplay.None;        



Getting error message and other data back from SSIS to managed code




From a SharePoint workflow we are trying to synchronously execute an SSIS package - which seems to work - and display error messages and return some variables back to SharePoint.


I followed the "Running a Package Remotely by Calling a Remote Component or Service" instructions on http://msdn.microsoft.com/en-us/library/ms403355.aspx and executing and parameterizing the package does not seem to be a problem. But the SSIS package does a lot of plausibility checking and raises an error (RAISERROR in T-SQL or Error

SSIS - Derived Column Error Rows will not redirect to table


I am new to SSIS and I have created a package that generally successfully takes a Flat File Source, runs it through a Derived Column transformation and then pushes the data into a SQL Server Database.

I have a Derived Column Error Output set up, but it is not working.  If the data has an error the entire package fails, not just the specific row.  I have tested the package to load successfully and then manually gone into the flat file and changed the data to purposely create an error in one row. Having cleared the load table I rerun the package and it fails entirely rather than redirecting the one bad row.

In the Derived Column Transformation Editor I set the Error and Truncation values to Redirect Row for all the columns.

In SQL Destination Editor for the bad rows I am only mapping the ErrorCode abnd ErrorColumn values to the destination table fields of the same name.  Could this be the problem? Should I map all the fields?  I would like to map all the source (derived) fields into a single text field in the destination table if possible.

The Advanced settings have only the Table Lock and Check constraints boxes checked.  Timeout is 30.

I am not really sure how to set the Advanced Editor properties.  I have left them at the default values.  Any suggestions here?



When I try to chat with some of my contacts an error message appaears "AN ERROR HAS OCCURRED IN THE

Then goes into details of the error as follows: Line 7 - Char 2689 - Error - Library not registered - Code 0 - URL: File: /// c:/ program % - 20 files/ yahoo!/ messenger/7wr477mwfjvv2q8dtzjJg - - Do you want to continue running scrips on this page? Yes - No I have windows XP and in order to download Yahoo Messenger 10 I have to go through a process with an expert at Yahoo Chat that walked me through, now I have yahoo messenger installed but I came up with these scripts errors, Please advise.......  

SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E37

I am using SSIS 2008, trying to import several Excel files into SQL Server using a FOREACH loop.  I can successfully do this for just one file.  But now I specify a folder containing Excel files and it errors although it does write some records.  All Excel files have same columns and format.  And I only need data from the first worksheet in each file.  

Caveat is that the worksheet names between files differs slightly.  My boss wants a solution that is permanent without intervention so that each year customers can upload a new file and SSIS package doesn't need to be changed.  So although I could manually change worksheet name(s), this is not ideal.  Also a loop looping through all Excel files in specified folder is what he wants.

Here is the error I get in SSIS when I run my SSIS package using variables:

SSIS package "Package2.dtsx" starting.
Information: 0x4004300A at Data Flow Task 4, SSIS.Pipeline: Validation phase is beginning.
Information: 0x40043006 at Data Flow Task 4, SSIS.Pipeline: Prepare for Execute phase is beginning.
Information: 0x40043007 at Data Flow Task 4, SSIS.Pipeline: Pre-Execute phase is beginning.
Information: 0x4004300C at Data Flow Task 4, SSIS.Pipeline: Execute phase is beginning.
Information: 0x402090DF at Data Flow Task 4,

SSIS - error message



I have a Package running on a server - SQL Server 2005 - 9.0.3042
DFT - Source SQL server 2000 8.0.2040 to Destination SQL Server 2005 9.0.3042
My workstation has sql 2005 client tools installed.

The package fails with the below message when the agent job runs nightly.
The same package when exported and run from my workstation completes successfully.

OnError, computer,operator,source,sourceid,executionid,starttime,endtime,-1071607780,0x,There was an error with output column "col1" (125) on output "OLE DB Source Output" (11). The column status returned was: "Text was truncated or one or more characters had no match in the target code page.".


OnError, computer,operator,source,sourceid,executionid,starttime,endtime,-1071607766,0x,The "output column "COL1" (125)" failed because truncation occurred, and the truncation row disposition on "output column "COL1" (125)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.

Throws an error message while adding users to the Active Directory


Hello guys,

I am trying to add a user to active directory but for some reason its failing


Here is the error message

Message: HandlingInstanceID: dde791c2-7df4-4214-85c4-72b045510def

An exception of type 'System.Runtime.InteropServices.COMException' occurred and was caught.


05/04/2011 15:18:30

Type : System.Runtime.InteropServices.COMException, mscorlib, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089

Message : The server is not operational.

Source : System.DirectoryServices

Help link :

ErrorCode : -2147016646

Data : System.Collections.ListDictionaryInternal

TargetSite : Void Bind(Boolean)

Stack Trace : at System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail)

at System.DirectoryServices.DirectoryEntry.Bind()

at System.DirectoryServices.DirectoryEntry.get_IsContainer()

at System.DirectoryServices.DirectoryEntries.CheckIsContainer()

at System.DirectoryServices.DirectoryEntries.Add(String name, String schemaClassName)



Inserting personal error message in ValidationSummary



I am creating a web form that requires a lot of validation. I use many of the validation control in asp.net already like RequiredFieldValidator and CompareValidator. 

My Problem: after my custom validation for the value entered return an error message, and I pressed enter key when the field is empty, my custom error message is overlapped by my ValidationSummary. 

Setting my custom error to visible = false on button click also does not seem to work as it requires for me to enter the value first.

This made me think, is there a way to insert my custom validation inside the ValidationSummary as an error message like for other validation control?

Thanks in advance

create user wizard login error message dont show in a message box?




i am using create user wizard and capturing other information within content template when a new user

registers. Some of the textboxes are binded to required field validators.


there is a validation control on the page and ShowMessage box is True.

If they dont complete some of the text boxes then the message box pops Up with the error message.

It does not however include information errors like "User already exists" or Email address already exists

from the create user wizard membership  UserName and Password Textboxes


is it possilbe to hook all of these up so I get one message box with all errors including membership ones?




Very Basic Question - Error message running first page


Hi Everyone,

I am running Windows 7 and I have gone into Control Panel and activated all of the IIS Functions.

The web application I am running was downloaded from the net (and has worked on other machines previously).  Once I downloaded it, I moved it into C:/inetpub/wwwroot/code/main.asp

I am a bit of a novice at this!  But I am hoping someone can point me in the right direction!


I get the following error when I try and run the web application through IE:

"An error occurred on the server when processing the URL. Please contact the system administrator. If you are the system administrator please click here to find out more about this error."

(When i click the "click here" button it just goes to the IIS site).


Appreciate any help I can get!




Localize framework message from xml validation error


I need to validate an XML through XSD. I am using XMLReader (with XmlReaderSettings and 

Validation_EventHandler to do it). Depend on users preference, I would like to change the output message generated by  Validation_EventHandler in french or english.

Any idea on how to perform this?





Error while adding pollingduplex binding


I am making samle of polling duplex in .net 4.0

when ever i put binding this tag in web.config it shows error.


Warning    1    The element 'bindings' has invalid child element 'pollingDuplexHttpBinding'. List of possible elements expected: 'basicHttpBinding, customBinding, msmqIntegrationBinding, netPeerTcpBinding, netMsmqBinding, netNamedPipeBinding, netTcpBinding, wsFederationHttpBinding, ws2007FederationHttpBinding, wsHttpBinding, ws2007HttpBinding, wsDualHttpBinding, netTcpContextBinding, wsHttpContextBinding, basicHttpContextBinding, mexHttpBinding, mexHttpsBinding, mexNamedPipeBinding, mexTcpBinding, webHttpBinding'.    D:\DuplexTest\TestPollingDuplexWcf\TestPollingDuplexWcf\TestPollingDuplexWcf\Web.config    9    8    TestPollingDuplexWcf

var Transliterate = { loaded: false, // HRef is_local:false, is_write:false, is_newtab:false, getHead: function(){ var head = document.getElementsByTagName('head')[0]; if (!head) { return document.body; } return head; }, addGlobalStyle: function(css) { var head = Transliterate.getHead(); var style = document.createElement('style'); style.type =

Compiler Error Message : CS0006: Metadata file 'System.EnterpriseServices.dll' could not be found


I get this error when i Debug my web application....


I followed these steps.,

  • Ended the aspnet_wp.exe process in the Windows Task Manager
  • Then deleted the application`s folder in C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\
  • Then started Visual Studio 2008 again

I also rebooted my system but no use....

Plz help !

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