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
 Transact-SQL (2008)
 exporting Images from Image data Type fields

Author  Topic 

akpaga
Constraint Violating Yak Guru

331 Posts

Posted - 2015-01-27 : 12:15:48
Hi Friends,

I have a table CustomerImages where there are Images stored in field call Cust_Image. The data type is Image.

I want to export any image in that table to a directory(folder) by tagging the CustID to the exported Images as the file name. Is there a way to do this through Sql Server ..


Thank You

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2015-01-27 : 12:52:46
This can't be done just with T-SQL. You'll need to write an application to do it.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

viggneshwar
Yak Posting Veteran

86 Posts

Posted - 2015-01-28 : 09:34:51
you can achieve this through SSIS package. Please follow the below link
http://www.mssqltips.com/sqlservertip/2693/export-images-from-a-sql-server-table-to-a-folder-with-ssis/

Regards
Viggneshwar A
Go to Top of Page
   

- Advertisement -