.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

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

Posted By:      Posted Date: September 29, 2010    Points: 0   Category :Sql Server



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

View Complete Post

More Related Resource Links

Smart Storage: Protect Your Data Via Managed Code And The Windows Vista Smart Card APIs


Smart cards are a compelling alternative to the reliance on passwords, which are the weakest link in authentication systems. Get the Windows smart card programming basics here.

Dan Griffin

MSDN Magazine November 2006

override error message (The value 'test' is not valid for Age) when input incorrect data type for in


Hello everyone,

I've tried to override error message when input incorrect data type in input field on HTML form. For example I have the model like this.

public class Person
public string FirstName {get;set;}
public int Age {get;set;}


For view, I put text input for Age to get it value.

When type some string in Age text box like 'test' and press submit button. I got this error message

The value 'xxx' is not valid for Age

However, I want to change this message and try many way. There 's nothing effect this message value.

Please could you help me to solve this problem.

Error message when importing data

Goodday , I get this error message when trying to import data from xls format.  Any suggestions Thanks Rob TITLE: SQL Server Import and Export Wizard Could not retrieve table list. ADDITIONAL INFORMATION: Cannot generate SSPI context SQL Server Network Interfaces: The Local Security Authority cannot be contacted (Microsoft SQL Server Native Client 10.0) BUTTONS: OK  rh

Solved: LDAP authentication: error code 49 - 80090308, comment: AcceptSecurityContext error, data 52

Hi, I have a problem conneting to another domain (far.away.domain). We have a two-way trust to this domain. Also I can access the DS using ADSI edit and our Administrator account (ourdomain.com). I tried several types of credentials (userid = "CN=Administrator,CN=Users,DC=ourdomain,DC=com", "Administrator @ ourdomain.com" (without blanks)...). Connecting to ourdomain.com is no problem, but to far.away.domain I can't connect, I always get the error 525 (user not found). What could be the problem? Have I to use an entry from the ForeignSecurityPrincipals CN of the far.away.domain? I also tried to connect using Softerra LDAPBrowser and a command line ldapsearch without succes and with not a better error message. But why is it not possible to use a trusted account, or is this a active directory feature and does not work with pure LDAP bindings? Best regards, Nils.

Excel Data Source SSIS AcquireConnection failed 0x80004005 unspecified error

Nuances of using Excel data sources with SSIS Your Development Machine Setup Needs Jet Drivers, available along with the default Office install so if you have Excel working fine locally, this is enough. Installing the "Office Data Connectivity Components" (download file name AccessDatabaseEngine.exe) as well as having Office installed corrupts the Jet Driver stack so that SSIS in VS 2008 cannot create the object to read the XLS file. You will see the title error "Unspecified Error" and "80004005" code. Resolution: Uninstall the Jet Engine pack on your development XP machine if you have Office. It will be listed as something like "Microsoft Access Database Engine (2010)". Run Office 200x setup with the Repair option and reboot. Try configuring the task in SSIS and it should be able to read the Sheet names again and columns.  Live Server (32-bit and 64-bit) Deploying your SSIS package to a server without Office 200x means it will not have the Jet Engine drivers to read XLS, XLSX files. You must install the 32-bit Office Data Connectivity Components - Jet Drivers mentioned above found here  (http://www.microsoft.com/downloads/details.aspx?familyid=7554f536-8c28-4598-9b72-ef94e038c891&displaylang=en). There are no 64-bit drivers; therefore regardless of 32 or 64-bit live environments, this step is the same. You shoul

SQL ServerDestination error - Unable to prepare the SSIS bulk insert for data insertion.

Having searched the forum, this one clearly has form... However beyond assisting those who have fallen at the first hurdle (i.e. forgetting/not knowing that they cannot execute the package remotely to the instance of SQL Server into which they are inserting), the issues raised by others have not been addressed. Thus I am bringing nothing new to the table here - just providing an executive summary of problems which others have run into, written about, but not received answers for.   First the complete error: Description: Unable to prepare the SSIS bulk insert for data insertion.  End Error  Error: 2008-01-15 04:55:27.58     Code: 0xC004701A     Source: <xxx> DTS.Pipeline     Description: component "<xxx> failed the pre-execute phase and returned error code 0xC0202071.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  4:53:34 AM  Finished: 5:00:00 AM  Elapsed:  385.384 seconds.  The package execution failed.  The step failed.   Important points It mostly works - It produces no error more than 9 times out of 10. It fails on random dataflows - My package has several dataflows, (mostly) executing concurrently. Where the error occurs it does not do so on the same dataflow each time: on one run it'll fail on dataflow A whilst B,C,D and E succeed, then A-E will all succeed (and continue doing so for the next ten runs thereafter), and

Data binding - strange error message

Hi, I am getting an inexplicable error message on attempting to run a simple WPF data binding application based on an example with video downloaded from MSDN. VB / VS 2008 Pro / .NET 3.5 SP1 / XP SP3 The error (ex.Message) is "The specified registry key does not exist" in response to an attempt to define the data context to populate a listbox, but no explicit registry operation is involved at all. The code is: Private taTable1 As New D1DataSetTableAdapters.Table1TableAdapter Private D1Data As New D1DataSet . . . Try     Me.taTable1.Fill(Me.D1Data.Table1)     Me.DataContext = Me.D1Data.Table1        ' this statement generates the exception Catch ex As Exception The error message is giving no obvious clue.  What is going on? P.S. The MSDN sample application uses the following code to sort the listbox items: Me.DataContext = From p In Me.dsProduct.Product Order By p.Name This construct does not work when I try to use it - VS 2008 reports that "'Name' is not a member of 'System.Data.DataRow'".  How may this error be avoided? JPL

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

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

ASP.net UPS void wsdl error message 'exception has been raised as a result of client data'


exception has been raised as a result of client data. at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol

Void shipment erro message; I can't determine how to resolve error.  at ***

The following is the code for ups void shipment wsdl...

protected void wsdlRate()


RateWSs.RateRequest rateReq = new RateRequest();RateWSs.UPSSecurity rateSecurity = new RateWSs.UPSSecurity(); RateWSs.UPSSecurityServiceAccessToken rateToken = new RateWSs.UPSSecurityServiceAccessToken

.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



When I execute a DTSX (which was developed in BIDS 2005) in through

command prompt (on a server which only has SQL Server 2005 and SSIS 2005) using dtexec.exe against /File paramger, it was working perfectly fine.

However, I get the following error message after executing on a server which has SQL Server 2005 and SSIS 2005 & 2008.  Is it possible to execute a DTSX, which was developed in BIDS 2005, on a server that has both SSIS 2005 & 2008?  Please advise.  I often get the following error message in such case.  Thanks!


    "c:\Program Files\Microsoft SQL Server\90\DTS\Binn\dtexec" /FILE \\server123\DATA\AMP.dtsx /DECRYPT PassWordd > \\server123\DATA\output.txt

Error MSG:

     Microsoft (R) SQL Server Execute Package Utility
Version 9.00.4035.00 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Started:  8:40:30 PM
Error: 2010-09-26 20:40:30.84
   Code: 0xC0011007
   Source: {0C157B60-C291-43ED-84A9-23F0DC7D5862}
   Description: Unable to load the package as XML because of package does not have a valid XML format. A specific XML parser error will be posted.
End Error
Error: 2010-09-26 20:40:30.84



I have a package that connects to IBM DB2 and imports data and saves it into text files.There are around 200 txt files. am using IBM OLEDB provider for DB2. After importing data into some text files like may be 50 or 70 or 100 or 170 , my package fails with error

SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager  failed with error code 0xC0202009.

help needed plz...

SSIS: Error in the package when the data in the flat file source is modified


Hi All,

I have a package which loads data from a flat file source to an OLEDB destination, which is executed successfully and data is loaded perfectly.

But later when the data in the flat file source is modified i.e. if an extra column gets added to the text file, the package is throwing an error because it is unable to detect the extra added column.

How can i avoid this error??? I need my package to execute successfully ignoring the changes(added columns) happened in the flat file source.

Please provide me wth your suggestions and solutions....

Thanks in Advance!!

SSIS Error Text was truncated or one or more characters had no match in the target code page


I the same issue or something close.

Except I have one Field (27) that get a trunacation error


Data conversion failed. The data conversion for column "Column 27" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".

The "output column "Column 27" (91)" failed because truncation occurred, and the truncation row disposition on "output column "Column 27" (91)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.


Data looks like:Red Text is the field that is throwing the error!





"RUTH           ",

"EDWARDS             ",









"1447203880    ",


Error Message: String or binary data would be truncated. The statement has been terminated




I have the following problem.

When I edit a field in the SQL Server Management Studio Express then I get the following error:

Error Source: .Net SqlClient Data Provider
Error Message: String or binary data would be truncated.

The statement has been terminated


When I use the SQL update commando, it works fine.

Fore debugging we need to change the enabled field several times.

Is there a solution fore this?



The Table Layout

USE [Project]


/****** Object: Table [dbo].[Proces] Script Date: 06/02/2008 10:01:20 ******/

OCIEnvCreate failed with return code -1 but error message text was not available.



We have a requirement to connect to oracle from ASP.NET and we installed ODAC(ODAC1110621) components  on the server but still we are getting the following error while opening the connection. Please find the details below:-

OCIEnvCreate failed with return code -1 but error message text was not available.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Exception: OCIEnvCreate failed with return code -1 but error message text was not available.

Source Error:

Line 16:     {
Line 17:         OracleConnection con = new OracleConnection(ConfigurationManager.ConnectionStrings["HRDBA"].ConnectionString);
Line 18:         con.Open();
Line 19:         Label1.Text = con.State.ToString();
Line 20:         con.Close();

Source File: \\hs003fs01-02.homebase.com\wfmp\Webpage1.aspx.cs    Line: 18

Stack Trace:

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