Search code examples
ssisrelative-path

Accessing script file stored in Miscellaneous Folder of SSIS


I would like to store some sql scripts on miscellaneous folder and need to execute those in ssis package. But I'm unable to find a way to access files in miscellaneous folder.

Note : Using project deployment model. So access using the full path will not help


Solution

  • when the .ispac is created, the files in misc aren't bundled along.

    Hence, for project deployments we can use the files inside miscellaneous folder

    thanks for the answer @vhoang on comment