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.