I am a programer by trade and i hate to expose raw passwords in any text document. I attached a small text file that you will need to rename as a bat file. (The file includes comments.)The batch file will allow the user to enter the password when they want to run the report.
You will need to run it from the command line.
I assume that most of you will need to write to an XML file and batch files do not like some special characters like < or >. I added code to generate two lines of XML with special characters to show you how to use the special escape character in a batch file.
REM Exit if they didn't enter a password
IF [%1]== Goto BadPassword
REM Write the XML header and comment line.
ECHO ^<?xml version="1.0" encoding="UTF-8"?^> >MyTest.dtsconfig
ECHO ^<!-- Generated dtsconfig file from %0 --^> >>MyTest.dtsconfig
ECHO User=Test >>MyTest.dtsconfig
ECHO Password=%1 >>MyTest.dtsconfig
ECHO Test file created with a password
REM "C:\Program Files\Microsoft SQL Server\110\DTS\Binn\DTEXEC.exe" /File "C:\SSIS\TestPackage.dtxs" /Conf "MyTest.dtsconfig"
ECHO ************* Bad Password ****************