Order Variables and Categories of a SSIS Custom Task/UI

Actually there is no any built-in property or member to order variables and/or categories. By default system order variables as their position and for categories use alphabetical order. So we have to use tab (\t) technique to let system order as its way but in our order. Rules is, more tab means order position first. System will not show tabs (\t), but texts.

See the below example to order categories but variables will be ordered as their position.

According to below example system will show as following order …

·         Excel Details

Ø  FilePath

Ø  FileName

·         Excel Sheet Details

Ø  SheetNames

[Category("\tExcel Sheet Details")]   // order position low

        public string SheetNames

        {

            get

            {

                return this.loadableSheetNames;

            }

            set

            {

                this.loadableSheetNames = value.Trim();

            }

        }

      

 [Category("\t\tExcel Details")]    // order position high

        public string FilePath    // order position 1^st

        {

            get

            {

                return this.path;

            }

            set

            {

                this.path = value.Trim();

            }

        }

       

[Category("\t\tExcel Details")]    // order position high

        public string FileName   // order position 2^nd

        {

            get

            {

                return this.fileName;

            }

            set

            {

                this.fileName = value.Trim();

            }

        }

See also -- Execute SSIS package from SSIS Script/ C#