How to open file which is stored under Miscellaneous folder of a SSIS package from a Script Task?

Question

I added solution related miscellaneous files into the SSIS package under the Miscellaneous folder, e.g. XML, Excel files. I need to open and read those misc. files in a SSIS Script Task, but I can't find the way either to read or getting the path of the misc. files. I'm using SSIS 2005 in the environment. Please kindly advise.

Thanks! William Choi

Answer 1

To get the path to the files, you can open the Properties window while the file under Miscellaneous is selected. This will show the Full Path and the File Name.