Add custom sql code to packager script

mspatchmspatch Posts: 2
edited April 24, 2006 1:08PM in SQL Packager Previous Versions
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

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    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.
Sign In or Register to comment.