Data Flow Task

Step 1

獲取二進(jìn)制圖片數(shù)據(jù)

declare @path varchar(100)='C:/labs/Images/'SELECT ThumbNailPhoto,@path+ThumbnailPhotoFileName as Pathfrom PRoduction.ProductPhoto

Step 2

在Export Column里面設(shè)置 Extract Column和 File Path