A blog about SQL Server, SSIS, C# and whatever else I happen to be dealing with in my professional life.

Find ramblings

Monday, October 8, 2012

Row Count with SSIS EzAPI

Haha, this is a trick. There is no EzAPI component for Row Count Transformation. Until now!
    [CompID("{150E6007-7C6A-4CC3-8FF3-FC73783A972E}")]
    public class EzRowCountTransform : EzComponent
    {
        public EzRowCountTransform(EzDataFlow dataFlow) : base(dataFlow) { }
        public EzRowCountTransform(EzDataFlow parent, IDTSComponentMetaData100 meta) : base(parent, meta) { }

        public string VariableName
        {
            get { return (string)Meta.CustomPropertyCollection["VariableName"].Value; }
            set { Comp.SetComponentProperty("VariableName", value); }
        }
    }

No comments: