Last post Dec 21, 2010 12:32 PM by psivait
Dec 21, 2010 07:42 AM|psivait|LINK
I am trying to export images from my SQL server to SSIS's Flat file destination but keep getting the same error:
Error 0xc0208030: Data Flow Task: The data type for "input column "image_full" (105)" 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)
The data type is IMAGE in SQL DB. I would like to export the image and save the same in local folder. Is their any way to perform this task using SSIS flat file destination? What is the best and easiest way to do this? What format should I be exporting
to? Has anyone ever had this problem? Please let me know if anyone could help or point me in the right direction.
Dec 21, 2010 12:32 PM|psivait|LINK
It is finally achieved using "Exports Column" task in Data Flow tab in SSIS.