Running a long script within the package

jbrodinjbrodin Posts: 5
edited April 4, 2005 10:17AM in SQL Packager Previous Versions
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.

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hello JBrodin,

    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.
This discussion has been closed.