This website requires JavaScript.

SSIS: 把存储在数据库中的图片导出来

Data Flow Task

image

Step 1

获取二进制图片数据

declare @path varchar(100)='C:\labs\Images'

SELECT ThumbNailPhoto,@path+ThumbnailPhotoFileName as Path from Production.ProductPhoto

![image](http://images.cnitblog.com/blog/378031/201504/041719082175378.png "image")

Step 2

在Export Column里面设置  Extract Column和 File Path

image

0条评论
avatar