Hello!

I have a few File Tasks in SSIS that rename files. Through Visual
Studio I can execute the package and it works great. When I attempt
run this pacakge via SQL Agent, Command Line or the Integrated Services
Engine it will finish with success however the files that are supposed
to be renamed are all gone. When I look at the logs SSIS states it is
deleting those files. I verified the File Tasks are set to rename and
not delete. Has anyone else experienced this or understand what I may
be doing wrong? Thanks!!

Check the file and folder permission for the SQL Agent account.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


"jenileo" <jenileo (AT) yahoo (DOT) com> wrote

Arnie Rowland wrote:
I did check that to make sure. It's interesting because I can watch it
create the original file, the file size grows so the import to text is
successful, then it disappears. The log states the the file has been
deleted but the file name it uses is the new file name. Both the
original file and new file are gone.

It sounds like an step output file, that is written over by subsequent
steps.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


"jenileo" <jenileo (AT) yahoo (DOT) com> wrote

It sounds like an step output file, that is written over by subsequent
steps.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


"jenileo" <jenileo (AT) yahoo (DOT) com> wrote