I am trying to Export data from Sql Server. Source data type is blob. when I export using SSIS I can export everything into one file. I am trying to replicate the same in Data Services
In BODS it is creating one file, where depending the the size of the blob it either references a file or it create includes the blob in the output file.
here's what the SAP reference Guide says
4.1.7.1.1 File format considerations for long You can define long data type columns in Data Services delimited files, XML files, and XML messages. The long data can be in the file or can reference an external file. The notation for this external file is <<filename>>. The software automatically generates the file name. For example, consider a comma-delimited file format that contains the following database columns. Table 277: Column name Data type ProductNo integer Description long Picture blob In Example 1, the long data appears in the file, but in Example 2, it references a file. The file name designates a path relative to the original input/output file or an absolute path. Example 1: 7369,WidgetA transforms questionable data into trusted sources through a single environment.,<<pictures\WidgetA.jpg>> Example 2: 7499,<<descriptions\WidgetC_descr.txt>>,<<C:\Widgets\pictures\WidgetC.jpg>>
is there other manual work around to include all of the blobs contents in the same export file instead of creating the reference file?
Request clarification before answering.
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.