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.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 | <FilterProperties("GetProperties"})> _Public Class ScriptMain...Public Function GetProperties() As String() Dim result As New ArrayList Call result.Add("Action") ' Action is always included. If Me.Action = "Upload File" Then Call result.Add("SourceFil") ElseIf Me.Action = "Download File" Then Call result.Add("TargetFolder") End If Return CType(result.ToArray(GetType(String)), String())End Function |
You may also check the sample script Http Upload/Download Task
Book a Presales Call
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
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 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 ...How to upgrade a script in Script Component Plus from 2005 to 2008
How to upgrade a 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 they ...