How to sort parameters
- To sort parameters according to a custom defined order, specify the SortProperties attribute on the parameters class.
1 2 3 | <SortProperties(New String() {"Connection", "TargetFile", "Database"})> _Public Class ScriptMain… |
Book a Presales Call
Related Articles
How to upgrade a script in Script Task Plus from 2005 to 2008
How to upgrade your script from 2005 to 2008 In order for this process to work, you must have both SQL 2005 and 2008 installed side-by-side on the same machine. Most of the scripts published in the public script repository are for SQL 2005. However ...Why can't I get the script samples published at public repository to work? I don't see any initialization parameters.
The most probable reason for not seeing the script initialization parameters is that the script code failed to compile. Do the following: Break the link to the script task. Go to Script tab and open script IDE. Open the errors pane and check if there ...Where can I find scripts for the Script Task Plus and Script Component Plus?
Although no longer supported, scripts for the Script Task Plus can be found at the following link. We are now supporting scripts for JavaScript Task and JavaScript Component instead. JavaScript Task is an SSIS Control Flow Task that allows ...How to filter parameters
To filter parameters based on the current state, specify the FilterProperties attribute on the parameters class. Specify the method name as attribute parameter. The specified method is dynamically called every time the class parameters are refreshed. ...How to validate parameters
To validate parameters, specify ValidateProperties attribute on the parameters class. Specify method name as attribute parameter. The specified method will be called when the user presses OK in the dialog. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 ...