Add custom sql code to packager script

mspatch

I've just recently purchased packager and was told that I can add custom sql code to the packager scripts. I've created a project and after the scripts are created I want to edit the scripts to include the addtional code that I need. How can this be accomplished?

Thanks,
mspatch

Brian Donahue

Hello,

I think someone stretched the truth with you just a bit. You can do this if you modify the PackageExecutor class and use the ExecuteSql method to run some SQL just before and/or after the main loop in the Execute method, then compile the script. The SQL code produced by Packager is an embedded resource in your c# project, but it's essentially a serialized ExecutionBlock object and it really shouldn't be edited directly.

Hopefully this points you in the right direction.