.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

Import error

Posted By:      Posted Date: October 05, 2010    Points: 0   Category :Sql Server


I having some truble importing a txt file in to SQL Server express 2008 R2 using the import Export Wizard.

The error occur in the executing stage:

- Executing (Error)


Error 0xc02020a1: Data Flow Task 1: Data conversion failed. The data conversion for column "CAPTION1" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
(SQL Server Import and Export Wizard)

Error 0xc020902a: Data Flow Task 1: The "output column "CAPTION1" (194)" failed because truncation occurred, and the truncation row disposition on "output column "CAPTION1" (194)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
(SQL Server Import and Export Wizard)

Error 0xc0202092: Data Flow Task 1: An error occurred while processing file "E:\USA Data\Sept_2010_Res_Bus\bdfoutfinal_oneper.txt" on data row 70.
(SQL Server Import and Export Wizard)

Error 0xc0047038: Data Flow Task 1: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Source - bdfoutfinal_oneper_txt" (1) returned error code 0xC0202092. The component returned a failure code when the pipeline engine called PrimeOutput()

View Complete Post

More Related Resource Links

BDC Import error with ADD


I want to try the BDC features so I created a test database with 2 tables related table (Building, Contact, Building has a foreing key to Contact). I used the Application Definition Designer furnished with the MOSS SDK to create the xml file. I was expecting it would be easy and straightforward but the produced xml file isn't working.

I get the following error when I try to import the Application definition:

Application definition import failed. The following error occurred: Entity could not be found using criteria 'name LIKE [SP_Test].[dbo].[Contact]'. Error was encountered at or just before Line: '140' and Position: '16'.

<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<LobSystem xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog BDCMetadata.xsd" Type="Database" Version="" Name="Building" xmlns="http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog">
  <LobSystemInstance Name="Building_Instance">
    <Property Name="rdbconnectionData Source" Type="System.String">MOSS2007</Property>
    <Property Name="rdbcon

Error Consuming Web Service - Unable to import binding xxx from namespace ...


In VS2008 / C# / ASP.NET 3.5, I wrote a test web service app. Here is an extract from the code:

namespace emed.MathWebService
    /// <summary>
    /// Sample Math Services For Learning Web Services Deployment
    /// </summary>
    [WebService(Namespace = " http://localhost/MathService")]
    [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
    public class MathService
        public float Add(float a, float b)
            return a + b;


I have published this to an IIS virtual directory named MathService, and when I try to launch it with the URL http://localhost/mathservice/MathService.asmx is works fine and displays all the operations (Add, Subtract etc) in the service.

I then created a test web application in VS2008 (named WebSvcTe

SSIS Import/Export Wizard: "Unexpected Unrecoverable Error"

For whatever reason, whenever the SSIS Import/Export Wizard needs to display an error message, it throws up "Unexpected Unrecoverable Error" instead. The three buttons - Abort, Retry, and Ignore - all cause the wizard to close. I see some activity in Process Monitor that looks like DTSWizard.exe is probing around for some System.Web assemblies, and not finding them. I'm running 2008 SP1 on Win 7 x86, and I've reinstalled the client tools and Integration Services. Anybody else seen this issue? Should I file a report on Connect?

Import Error: Could not process the file Documents/Application Deployment.mht as a Single File Web P

Hi there everyone, Version: Windows Sharepoint Services 3.0 with Cumulative Update June 29, 2010 applied. I am having issues importing an exported site into a different domain. I've overcome most of the issues and actually got most of the site to import, however, the import process get's stuck on import a Single File Web Page document from a document library. I believe the original cause of this error is http://support.microsoft.com/kb/980079 The issue I face now is, I already have a large number of .mht files in my document library which I do need to import into the test environment (or that I might need to restore in a DR scenario). Does anyone have any information on either: forcing the import commmand to "on error resume next" (ie. not stop processing when it encounters an error) fixing the already corrupt .mht files in the database easily The error text from the import command is: Error: Could not process the file Documents/Application Deployment.mht as a Single File Web Page document. at Microsoft.SharePoint.Library.SPRequest.CreateOrUpdateFileAndItem(String bstrUrl, String bstrWebRelativeUrl, Guid& docId, Object varDoc, Int32 docLength, Int32 exists, String bstrCreatedBy, String bstrModifiedBy, Int32 iCreatedByID, Int32 iModifiedByID, Int32 iVersion, Object varTimeCreated, Object varTimeLastModified, Object varProperties, String checkInComment, Int3

SSIS Import Package Error - DTSRuntimeWrap 0xC0010026

Hi, I have a problem with importing dtsx package on SSIS 2008. When I try to import this in SSIS MSDB, I have an Exception from HRESULT: 0xC0010026 (Microsoft.SqlServer.DTSRuntimeWrap). The related topic does not help me, because the package is generated in 2008 version, imported with 2008 Management Studio. Any idea? Thanks a lot, Giovanni

Import-SPWeb, List does not exist error

I have a strange problem with custom lists in an imported site.
After exporting the site in Central Admin by clicking "Export a site or list" and importing it with "Import-SPWeb" (on a different farm), I cannot read or create new items in custom lists in the imported site. However, by code, i.e. using PowerShell or custom Web Parts, I can read items in the list without any problems.

If I click on any item in a list however, I get an error saying "List does not exist. The page you selected contains a list that does not exist.  It may have been deleted by another user."

I guess it has something to do with permissions, since I get an "Access denied" error when trying to create new items through the browser. The permissions settings seem fine in the browser though...

EDIT: This seems to occur only on lists where I have created custom list forms, like Disp and Edit pages. I guess it has something to do with these files. Are any one else having the same problem?

EDIT 2: Correction, this occurs on every list.

Error on mapping oracle varchar2 to sql server 2008 using import facility, defaults to type 129 in m



I am trying to use the import wizard to import an oracle 10g table into an sql server 2008 (10.0.2531) database, it comes up with the error 'data types of source columns were not mapped correctly to those available on the destination provider'. When I go into 'edit mappings' it shows all the varchar2 oracle columns mapping to type 129 ? all the other columns have normal mapping types. If i go through and change 129 to varchar the import will work ok.

I understand that in c:\Program files\microsoft sql server\100\dts\mappingfiles there is a series of files that map datatypes to/from different sources, there are 3 files

oracleclienttomssql , oracleclienttomssql10 , oracleclienttossis10 which have a varchar2 to nvarchar mapping

and 2 other files  oracletomssql ,  oracletomssql10 which map varchar2 to varchar and one other file, oracletossis10 which maps varchar2 to dt_str

I running the import on a server with an Oracle client installed with sql server 2008 (10.0.2531).

I am not sure which mapping file is being used ? and whichever one is being used it should provide a mapping rather than type 129 (whatever that is).

I would like to get this mapping resolved as I have many tables to import and over time the structure of the Oracle tables will change so I want to use import as the easiest optio

Profile import from Novell eDirectory (Error One or more values typed on this page are not valid)


We have a requirement to authenticate the users to Active Directory but get their profile information from Novell GDS. Accounts are syncronized between Novell and Active Directory by the Novell Identity Manager Solution.

In a POC environemnt we are trying to import the profile information from Novell GDS according to the following configuration:

·     Connection Name: Novell

·     Type: Novell eDirectory


Cannot Import application Definition to Business Data Catalog (BDC) -- Error: Access Denied

I want to import an application definition to my Business Data Catalog (BDC).

I log into my Shared Service and select Import application definition.

I am redirected to page that says Error: Access Denied

My account is:

1. An Administrator on the windows server running sharepoint
2  A member of the Farm Administrators
3. Added individually with Full Control to Central Administation
4. Added individually with Full Control to my shared service.

John Bailo

SSIS Package Import - invalid access to memory location ERROR



     Im using Sql server 2005 sp2 enterprise edition and trying to import a package onto Server using Import wizard when you right click MSDB after connecting to Integration services server in Management studio.

     I have MSDB on a named SQL instance and SSIS on a different instance. I have modified the server configuration XML in 90 folder to point to named instance server.

     when trying to import a package its throwing a error Invalid access to Memory location.

I have tried registering the 2 dll's i found in other posts but no use.


Any help would be appreciated...





SQL Express R2 - Import / Export Data (32-bit) - Excel - Unexpected Unrecoverable Error


Preface - I'm BRAND NEW to SQL! Bought a book and working to learn :) I've have a lot of experience in Access and other msft titles.

I've installed SQL Express 64 bit on Win 7 (64) and I'm trying to setup my 1st table to start practicing running queries on and I’m having nothing but trouble!! I'm trying to use the import / export wizard to import Excel '07 spreadsheet that has a table of data and I CANNOT get through this without crashing! EVERY SINGLE TIME!

My Steps:

1.  Open Wizard

DTSWIZARD (import/export utility) - Error trying to use VFP OLEDB provider


A week ago I was using SQL Server 2008 Express and the DTSWIZARD was working fine when I selected the Microsoft OLE DB Provider for Visual FoxPro as the data source for the import data. The wizard only allows me to RUN the import and not SAVE it saying I needed to upgrade to Developer/Enterprise edition of the server to be able to save the attributes of the import (for reuse).

So, I downloaded SQL Server 2008 R2 Enterprise as an MSDNAA (faculty) person. I installed both R2 Enterprise and R2 Express. I don't really need Enterprise (which is good because I cannot get it to START no matter what I try...which is another issue not related to this one I am writing about here).

I now have the version/feature for DTSWIZARD that allows me to save my import attributes (yea!)...however, the problem now is when I select the Microsoft OLE DB Provider for Visual FoxPro as the data source for the import data I get the following error message when I click NEXT: Feature is not available (Microsoft OLE DB Provider for Visual FoxPro). If I click the Properties... button (to select the VFP database) I get this error message: Unexpected Unrecoverable Error  and the wizard quits when I click any of the 3 buttons on that pop up message.

The VFP OLE DB provider is ALIVE AND WELL (I think) on my Windows 7 Ultimate 32-bit laptop as I am

Import XML File to SQL Table

Here is a brief example of importing an XML file into SQL Server table. This is accomplished by using the BULK option of OPENROWSET to load the file, and then utilizing the XQuery capabilities of SQL Server to parse the XML to normalized table format. This example requires SQL server 2005 or SQL Server 2008.

First, the following XML is saved to XML file C:\Products.xml.

IsapiModule Error 500 Issue


I am about exhausted trying to figure out this error:

HTTP Error 500.0 - Internal Server Error

Description: The page cannot be displayed because an internal server error has occurred.

Error Code: 0x8007007b

Notification: ExecuteRequestHandler

Module: IsapiModule

Requested URL: http://localhost:80/ReportServer

Physical Path: c:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer

When I enable Failed Request Tracing Rules and view the log output I am supposing that the actual problem is in the 2nd call where there are 2 backslashes before the actual filename in the specified path:


CALL_ISAPI_EXTENSION DllName="C:\Windows\Microsoft.NET\Framework\v2.0.50727\\aspnet_isapi.dll"


Handling 404 page not found with Error page



      How do i handle 404 page not found?

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

Sys.Net.WebServiceFailedException: The server method '' failed with the following error:



Let's say we have 2 time consuming functions, aaa and aaa1 inside a aspx page.

        public static string aaa(int i)
            return i.ToString();

        public static string aaa1(int i)
            return i.ToString();



        <asp:ScriptManager ID="ScriptManager1" runat="server" EnablePageMethods="true">
        <span id="displayspan"></span>
        <br />
        <input type="button" value=
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