Options
Running a long script within the package
jbrodin
Posts: 5
I have a long script and complex script that I would like to run after the package data script has run. I'd rather not include a .sql file along with the .exe package so I'm curious if you have any suggestions.
As noted in previous requests it would be nice to edit the scripts created by the package tool and be able to insert my own sql where required. Is there any timeframe estimates on supporting this.
As noted in previous requests it would be nice to edit the scripts created by the package tool and be able to insert my own sql where required. Is there any timeframe estimates on supporting this.
This discussion has been closed.
Comments
Thanks for writing us. We are looking into supporting the addition of SQL by the user in a future version, but at this point your only recourse is to modify the 'SQL Packager code template' project in the Red Gate SQL Bundle folder. It's possible to add your own SQL to be run after the batches produced by Packager for every package you produce by adding the SQL to the PackageExecutor.cs code.