What exactly is the use of Miscellaneous folder in the SSIS Solution folder hierarchy? I have use many packages and solutions as a part of the project,but never used this folder.I do understand that ,one can import various files over here. Can any body tell the practical scenario ,where this folder is being used?
Asked
Active
Viewed 2,192 times
5
-
2Personally, I've used it for the storage of associated documentation and processes related to the SSIS package. – Steph Locke Feb 27 '14 at 11:44
-
2All other files that you need in your project and that do not have the extension .dtsx will be dropped in this folder (f.e. documentation or SQL files). And if you install BIDSHELPER (bidshelper.codeplex.com) it will store the BIML files (for generating packages) in that same folder. – Joost Feb 27 '14 at 14:58
2 Answers
4
My two primary use cases are Biml files (which allow me to generate SSIS) and any sql scripts for migration of Environment and configuration of values.
billinkc
- 59,250
- 9
- 102
- 159
-
would like to execute sql script stored in misc folder from ssis. how do I ? – vignesh Nov 21 '19 at 10:18
1
We can keep the files which is not associated to the project or solution, but we will be tracking and using it in the solution. So for the quick accessing the file we can use this folder
Naveen Kumar
- 582
- 2
- 8
- 25