Hello,
I have created an SSIS package that loads databases from XML files located
in a certain directory. Prior to that I have bat file that ftps, decrypts,
and copies the XML files to that directory that the SSIS package reads from.
I had originally included an ftp task in the package; but abandoned it as I
needed to include PGP command line processing to decrypt the files -- which
is why I made a bat file to do so.

Can anyone advise either (1) how to incorporate the ftp and PGP command line
decrytpion in the SSIS package; or (2) how to create a job run by the SQL
server agent that includes the bat commands as its first step? (I have
successfully created a job that has a SSIS package step). For the (2)
option, I tried creating a CmdExec job step but was not sure how. In the Job
step properties window, I selected Operating system (CmdExec) for "Type"; SQL
Agenet Service Account for "Run as"; and for "Command" when I open my bat
file, it copies in its commands:
ECHO OFF
ftp -i -s:ftpgetfile.txt
pgp --decrypt *.pgp --passphrase *********
move *.xml E:\DailyFeedsourcefiles

Any advice is much appreciated.
Thank you,

Thomas