Post reply

How to get properties of ScriptBuffer in the ScriptComponent

  • October 14, 2009 at 3:12 am

    #136677

    I've created an Output metadata in scriptcomponent. One of the column in meta data is numeric with scale and precision values.

    Now in the script component when I read data into the scriptbuffer rowset I need to ensure if the data assigned has correct datatype and size specified in the metadata output scriptbuffer.

    Is there anyway I can read those scale and precision values of the metadata column inside script component?

    Bhavesh
    .NET and SQL Server Blog

  • October 16, 2009 at 10:05 am

    #1067021

    Bhavesh-1094084 (10/14/2009)

    I've created an Output metadata in scriptcomponent. One of the column in meta data is numeric with scale and precision values.

    Now in the script component when I read data into the scriptbuffer rowset I need to ensure if the data assigned has correct datatype and size specified in the metadata output scriptbuffer.

    Is there anyway I can read those scale and precision values of the metadata column inside script component?

    No, there is no way. If you can use third-party components, check the commercial CozyRoc Script Component Plus. The enhanced component allows access to the underlying PipelineBuffer class and you can then call GetColumnInfo method from there.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply