Procedure to Encrypt SQL Server DTSRUN Parameters
  1. Create a batch file with your DTSRUN command

    2. Example:

    Batch file: test01.bat contains

    DTSRUN /s biwgdcsql02 /u test01 /p goodby /n dts_test01

  2. Add /!y to the end of the DTSRUN command and save your batch file

    3. Example:

    Batch file: test01.bat now contains

    DTSRUN /s biwgdcsql02 /u test01 /p goodby /n dts_test01 /!y

  3. From DOS enter your batch file name followed by > text.txt

    4. This will put the results of the DTSRUN to file text.txt

    Example: c>test01 > text.txt

  4. Your text.txt file now contains your dtsrun command encrypted

    5. Example

    Text.txt file:

    D:\mystuff\DOCS\SQL Server\Bat>dtsrun /s biwgdcsql01 /u test01 /p goodby /n dts_test01 /!y

    DTSRun /~S 0x928F677DDD81FD0250CE162775417004D46FB7187384F1B7 /~U 0x61E3505D4C6A2496D5220748798FD9CC /~P 0xEBB63BFB2DA7637633434425CA5C22A0 /~N 0x5E4F2014862B0FFB4671509860E1217D68005C6C8D08A884 /!Y

  5. Cut and paste the encrypted parts that you will wish to encrypt into your original batch file