Legacy DTS package stopped working error: CreateProcessTask 'DTSTask_DTSCreateProcessTask_1': Process returned code 2

I have a FTP batch file which I call from DTS package. It all works fine when I right click on the package and execute it now. However when I schedule it, it comes with following error :

Step Error Description:CreateProcessTask 'DTSTask_DTSCreateProcessTask_1': Process returned code 2, which does not match the specified SuccessReturnCode of 0.
Step Error code: 80040496
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:4900
vraj20Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Anthony PerkinsCommented:
This has to do with the permissions for the SQL Server Agent service account.  Please check that this account has the appropriate permissions and that you are not using any mapped drives.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dbbishopCommented:
The problem is probably what Anthony pointed out. Some kind of access that you hav on your client that the server does not have. Common causes are, as he pointed out, mapped drives, pulling data from another server environment (e.g. Oracle) where you have the connection available but the server doesn't, etc.
0
vraj20Author Commented:
This solution was solved thru another process
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.