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)
 Blob Field Help

Author  Topic 

Sonu619
Posting Yak Master

202 Posts

Posted - 2011-06-24 : 00:24:57
My source has Blob Field (Column has LInk or you can hit world file to see whole description,This field actually contains a complete Microsoft Word document). I am using SSIS to transfer that field. In Data Conversion Transformation showing Data type of this field is "Image" My question is should i keep same data type "Image" or change to ? and how about destination field?
I am having problem if i use same source data type "Image" and destination data type "Image" or "ntext". Please let me know if need more information thanks.

latch
Yak Posting Veteran

62 Posts

Posted - 2011-06-27 : 09:26:45
http://www.shabdar.org/sql-server/105-store-save-images-in-sql-server.html
Go to Top of Page
   

- Advertisement -