Bi-Data Stream Conversion-import columns and export Columns

Import column:

The import column example is now used as an example:
Create path D: \ pictures
Paste 4 relatively small image files in path D: \ pictureswith the name 01.png%02.png%03.png%04.png
Create a TXT file named filelist.txt in path D: \ pictures. the file content is as follows:
D: \ pictures \ 01.png
D: \ pictures \ 02.png
D: \ pictures \ 03.png
D: \ pictures \ 04.png
Run the following SQL statement to create a table

CREATE TABLE dbo.MyPictures    (      [StoredFilePath] [varchar](100) NOT NULL ,      [Document] IMAGE    )    SELECT  *FROM    MyPictures    

 

Run the package after the setting is successful:

View the mypictures table in the target database. As follows:

Export column:

The following describes in detail the meaning of allowed append, forced intercept, and compiling of byte sequence columns in the window:

Column name	Description
Append allowed	Specifies whether to append data to an existing file during conversion. Default Value: false.
Forcible Interception	Specifies whether to delete the content of an existing file before the conversion is written. The default value is false.
Write byte order	Specify whether to write the BITs (BOM) into the file. Only when the data has the dt_text or dt_ntext data type and the data is not appended to the existing data file will the mark (BOM) be written)

Run the package. You can see that there are 4 files in the folder.

Bi-Data Stream Conversion-import columns and export Columns