Search code examples
ssisssis-2012

Include SQL scripts in SSIS package?

I have a few SQL scripts (e.g. create tables) that I would like to include in my SSIS project for the sake of tidiness and inclusion in the Git repository. They aren't used by the package itself.

Is there a good place for them (perhaps the Miscellaneous folder) ? Are there any issues with including them in the project?

Solution

  • We use this approach all the time, storing CREATE TABLE and other set-up scripts in the Misc folder. We've never had a problem with this approach.