User991566988 posted
Hi
I've dragged and dropped OLE DB Source and Export Column in an integration service project in visual studio 2019, and make the connection successfully to export Images from Image datatype column to some folder in Windows.
So I put this SQL command text in OLE DB Source:
DECLARE @path VARCHAR(100) = 'C:\Images\'
SELECT [image]
,@path+CAST([Id] as varchar(100)) AS Path
FROM [MyDB].[dbo].[SampleTable]
But when I double click on Export Column, The 'Extract Column' has 'image' value but 'File Path Column' has no value!
Why? and How to solve please?