Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 image file export/import to/from flat file

Author  Topic 

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2010-10-25 : 01:51:09
One of my table in database contains images (each image has size apporx. 6 mb, datatype for image is varbinary(max) and table saved in filestream datafile).
I want to export these records to a FLAT FILE and import to another database from this flat file.

HOW TO ACHIEVE MY TARGET.

i already had tried to export and import it (using NTEXT stream) but when fetch these records to other database, image file was found corrupt.
   

- Advertisement -