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

score -2 · Accepted Answer · answered Feb 08 '11 at 14:54

-2

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.

answered Feb 08 '11 at 14:54

grapefruitmoon

2,988
1
22
26

3

Thanks, but I'd like to find out the "relative" way. – William X Feb 17 '11 at 02:09
This is an answer to the question. Having the full path does not help. – Milan Nankov Dec 18 '18 at 14:42
full path will not help when we deploy project . – vignesh Nov 21 '19 at 12:10

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

1 Answers1