Download Images from SQL Table

Question

I am trying to download images stored in a table, as Photo (image, not null).

I will download to my local c:\temp\ folder.

Using the following

declare @path varchar(100)= 'c:\images\' SELECT [Photo],@path+[PhotoFileName] AS Path FROM [AIS_DEV].[dbo].[tblPhoto]

Getting this error.

Thanks,

---

jer

Answer 1

What for a tool are you using; that screen isn't from SSMS and your SQL statement is just a variable assignment; that won't cause any error?

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 2

I am trying to create an SSIS package. Learning as I go.

---

jer

Answer 3

Here you go

Export images from a SQL Server Table to a Folder with SSIS

https://www.mssqltips.com/sqlservertip/2693/export-images-from-a-sql-server-table-to-a-folder-with-ssis/

---

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Consulting: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
SQL Server Integration Services: Business Intelligence

Answer 4

Uri Dimant:

Thanks for that link, which is the guide I was trying to follow. But, thus my post because the Declare is my issue. Please see my screen shot and code.

Regards,

---

jer

Answer 5

Your SQL Statement don't make any sense. Better describe what you trying to achieve, post DDL of table and some sample data.

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 6

Trying to download images files from a table. Using the job-aid Uri, mentioned, thus my post because the declare statement is having issues:

Here is the code they used, I just replaced with my table information and Photo field name:

declare @path varchar(100)= 'c:\images\'

SELECT [ThumbNailPhoto]
,@path+[ThumbnailPhotoFileName] AS Path
FROM [AdventureWorks2012].[Production].[ProductPhoto]
mine:
declare @path varchar(100)= 'c:\images\' 
SELECT [Photo]
,@path+[PhotoFileName] AS Path 
FROM [AIS_DEV].[dbo].[tblPhoto]

---

jer

Answer 7

   Anyone has more ideas?

Answer 8

Why do you need DECLARE at all here? In order to download image and display it you need to write small .NET program,

https://stackoverflow.com/questions/39072270/display-image-in-picture-box-from-sql-server-in-vb-net-winforms

---

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Consulting: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
SQL Server Integration Services: Business Intelligence