Why can't I get the script samples published at public repository to work? I don't see any initialization parameters.

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 are errors.

If you see error stating CozyRoc.SSISPlus library cannot be found, open Add Reference dialog (from script IDE menu: Project -> Add Reference ...). If the dialog displays libraries only from your ... Microsoft.NET\Framework ... folder, you most probably didn't install SQL 2005 SP2. SP2 includes support for libraries found in Microsoft SQL Server\90\SDK\Assemblies folder and SSIS+ library is deployed there by default. Manually copy CozyRoc.SSISPlus.dll to your Microsoft.NET\Framework folder and try again.


    • 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 ...

    • 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 ...

    • 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 ...