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.