March 28, 2011 at 10:54 pm
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.
May 4, 2011 at 12:46 pm
Try the following links:
http://msdn.microsoft.com/en-us/library/aa176253(v=sql.80).aspx"> http://msdn.microsoft.com/en-us/library/aa176253(v=sql.80).aspx
http://www.sqldts.com/234.aspx"> http://www.sqldts.com/234.aspx
http://www.dotnetspider.com/forum/280871-Capture-error-message-DTS-package-SQL-task.aspx"> http://www.dotnetspider.com/forum/280871-Capture-error-message-DTS-package-SQL-task.aspx
http://www.bigresource.com/MS_SQL-Exec-SQL-Task-Capture-return-code-of-stored-proc-not-working-4n1HKZEs.html"> http://www.bigresource.com/MS_SQL-Exec-SQL-Task-Capture-return-code-of-stored-proc-not-working-4n1HKZEs.html
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply