Bundling SQL Scripts and other file-based resources in SSIS project deployment

Question

Is there a way you can add SQL scripts, or flat files in general, into SSIS projects such that they get bundled into the same ispac file with the dtsx packages?

Example use case: pulling the SQL code from an "execute SQL" task into a separate file where it can work with source control diffs more easily for peer reviews, etc.

It looks like miscellaneous files in the same project directory do NOT get bundled into the ispac, even when Visual Studio recognizes them as miscellaneous files in the project.

Answer 1

Nope. You Can't.

Source : MSDN - Deploy Integration Services (SSIS) Projects and Packages

The project deployment file does not capture all of the information contained in the Integration Services project file (.dtproj extension). For example, additional text files that you use for writing notes are not stored in the project deployment file and thus are not deployed to the catalog.

Since SQL scripts would also be text files with .SQL extension, it looks like they won't be included in the .ispac archive deployment file, even if you place them in the "Miscellaneous" folder inside your SSIS Project.