Post reply

Export/Import Error

  • March 28, 2011 at 5:18 am

    #248789

    Hi

    When i use export/import utility to transfer a view data to excel file,i am getting this error.

    The table is structure is

    Create table Emp(Eno int,ename varchar(20))

    But in view i created columns as

    Create view EMP_VIEW_DB3 as select Eno as [E.NO],ename as [E.NAME] from Emp

    When i export it excel file i am getting this error.actually i need to send the data to csv format .

    Pre-execute (Error)

    Messages

    Error 0xc0202005: Data Flow Task: Column "E.NO" cannot be found at the datasource.

    (SQL Server Import and Export Wizard)

    Error 0xc0202025: Data Flow Task: Cannot create an OLE DB accessor. Verify that the column metadata is valid.

    (SQL Server Import and Export Wizard)

    Error 0xc004701a: Data Flow Task: component "Destination - EMP_VIEW_DB3" (22) failed the pre-execute phase and returned error code 0xC0202025.

    (SQL Server Import and Export Wizard)

    Please Help me out from this.

  • March 31, 2011 at 5:06 pm

    #1306253

    does a simple

    select * from EMP_VIEW_DB3 work ?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply