How to upgrade a script in Script Task Plus 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 can be easily upgraded to SQL 2008 by following these 10 steps:
- Create the SSIS 2005 package and insert COZYROC Script Task Plus.
- Load a script in the task and break the link to the script. Save the package.
- Go to the SSIS 2008 solution. Right-click on the solution and select 'Add Existing Package'.
- Select the package you have created in step 1. SSIS 2008 will do an automatic upgrade of the package and show some warnings.
- Open the imported package.
- Double-click on the COZYROC Script Task Plus and enter the script IDE.
- Right-click on the script project and select Properties.
- Go to the References tab and add a reference to CozyRoc.SSISPlus.2008 from the "Microsoft SQL Server\100\SDK\Assemblies" folder.
- Save and close the project settings. Make sure the script compiles.
- Close the script IDE and export the script.
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 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 ...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 the documentation for the Script Task Plus?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the Script Task Plus can be found at the following link. For many of the components you can find ...Why can't I debug scripts? I set breakpoints and start the package in debugging mode, but it doesn't stop.
There is an issue in the SSIS framework. It verifies if there are breakpoints set in the standard Script Task and only then enters debug mode. We have found a workaround to debug your scripts. Insert a standard Script Task and set breakpoint in it. ...