How to insert null for blob datatypes into pipelinebuffer
-
09 Agustus 2012 17:32
I am developing a custom data flow source component.
I need the ability to write blob data types into the output PipelineBuffer, including setting null values.
The Pipeline.PipelineBuffer.SetNull() method is not supported for the blob data types (DT_IMAGE, DT_TEXT, DT_NTEXT).
The Pipeline.BlobColumn class has the ability to SetNull, but I can find no connection between the PipelineBuffer class and a BlobColumn.
Neil Thomson
Semua Balasan
-
09 Agustus 2012 19:19Moderator
I think you ought to stick to using the Pipeline.PipelineBuffer because it is the only one applicable, however indeed as per BOL the BLOB data types can not be set to NULL.
If this is a major limitation for you, you can file a suggestion request at Microsoft Connect.
Arthur My Blog
- Disarankan sebagai Jawaban oleh Eileen ZhaoMicrosoft Contingent Staff, Moderator 14 Agustus 2012 9:54
- Ditandai sebagai Jawaban oleh Eileen ZhaoMicrosoft Contingent Staff, Moderator 15 Agustus 2012 8:52
- Tanda sebagai Jawaban dihapus oleh Neil Thomson 15 Agustus 2012 13:31
-
15 Agustus 2012 13:34
There is an absolute requirement for all data types to know if a value is empty vs. null.
Given the lack of an answer, I'll have to work on the assumption of setting and detecting for these data types that a length of zero with an empty byte array is the equivalent of null.
For microsoft to leave such a gap in the definition of these data types is not helpful.
Neil Thomson
- Ditandai sebagai Jawaban oleh Neil Thomson 15 Agustus 2012 13:34
