I'm getting the attached errors when I run my query through the SQL Server Import and Export Wizard (SQL 2008R2).
I'm extracting table date to Excel. When I run the query via SSMS it runs fine. When I look at the Preview inside the Wizard it looks fine. I ran the same query on a smaller database and it ran fine. I know it has to do with size/number of records. It fails somewhere after row 65000. There are over 200000 rows.
Anyone have any idea how to fix this? I've read much online but can't get an fix specific to my issue. Someone mentioned in a post that in the Column Mappings the Source Type-Destination type entries might be causing it and need to be modified (example: Column Source Type=varchar, Destination Type=LongText).
Any help is greatly appreciated.