I want to export data of a table into a flat file. I am using SQL Server Management Studio Export Data option. One of the column type is image (BLOB) in the table I want to export to a CSV file. The data inside that BLOB type column is text (an XML).
The Data Export Wizard fails giving below error
The data type for "input column "BLOB_REQUEST" (84)" is DT_IMAGE, which is not supported. Use DT_TEXT or DT_NTEXT instead and convert the data from, or to, DT_IMAGE using the data conversion component. (SQL Server Import and Export Wizard)
I went back and used Edit Transformation option, I changed destination type to textstream DT_TEXT but it still failed with same error.
Kindly help how to export table data with BLOB/image column to flat CSV file?
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.