Data Flow Task
Step 1
獲取二進位制圖片資料
declare @path varchar(100)='C:\labs\Images\' SELECT ThumbNailPhoto,@path+ThumbnailPhotoFileName as Path from Production.ProductPhoto
Step 2
在Export Column裡面設定 Extract Column和 File Path
Data Flow Task
Step 1
獲取二進位制圖片資料
declare @path varchar(100)='C:\labs\Images\' SELECT ThumbNailPhoto,@path+ThumbnailPhotoFileName as Path from Production.ProductPhoto
Step 2
在Export Column裡面設定 Extract Column和 File Path