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 1st
{
get
{
return this.path;
}
set
{
this.path = value.Trim();
}
}
[Category("\t\tExcel Details")] // order position high
public string FileName // order position 2nd
{
get
{
return this.fileName;
}
set
{
this.fileName = value.Trim();
}
}
See also -- Execute Ssis package from SSIS Script/ C#
