How to export SQL Server 2005 rows to excel? Everytime I do it I get errors

I have SQL Server 2005 and I am trying to export a table into an Excel file.

I right click on my database and click export. I go through the wizard and choose to export to excel then I choose my one table that I want to export and hit finished.

I get this

Messages

Error 0xc0202009: Data Flow Task: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x00040EDA.
(SQL Server Import and Export Wizard)

Error 0xc0209029: Data Flow Task: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "Destination Input" (72)" failed because error code 0xC020907B occurred, and the error row disposition on "input "Destination Input" (72)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure. (SQL Server Import and Export Wizard)

Error 0xc0047022: Data Flow Task: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Destination - SchoolUsers" (61) failed with error code 0xC0209029. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. (SQL Server Import and Export Wizard)

Error 0xc0047021: Data Flow Task: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC0209029. There may be error messages posted before this with more information on why the thread has exited. (SQL Server Import and Export Wizard)

It seems to export one row and then it dies. I don't know why.

+1 those sql2005 wizards can be pretty buggy. Sometimes I've found the only way a text data import would work was to first import it into Access, then import that into SQL!

Jonny Cundall 2010-09-13 20:37:50

The sad thing is the wizards worked really well in 2000 much better than the 2005 and 2008 versions. I've learned on doing quick imports using the wizard (to see what the file is like before writing a real SSIS package with cleaning and all) to always go in and change the field size, what idiot thought 50 was a good standard?

HLGEM 2010-09-21 18:37:49

The 2 columns that I want are set a longtext. I changed them to varchar(..) but I still got the same errors.

chobo2 2010-09-13 20:30:51

Joe Stefanelli 2010-09-13 20:48:33

Did you try using a conversion step in the SSIS?

Sam 2010-09-13 22:42:35

@Joe no the columns are 20 and 100 characters long. @Sam I am not sure what "SSIS" is

chobo2 2010-09-14 00:59:46

SSIS Assumes all Excel data will be nvarchar, you may need to conver to that. And there are issues if you are on a 64 bit machine as well.

HLGEM 2010-09-21 18:35:01

ansaurus

tags:

views:

answers:

How to export SQL Server 2005 rows to excel? Everytime I do it I get errors

related questions