error on SSIS pack on sql 2012 Integration Services catalogs

hi
 i create a package form SSIS, it runs fine, but after i deploy into SSISDB  in sql sever, i got error "Flat file destination failed the pre execute phase and trturned error code 0xc020200E"
i am sure i have access right on that file, and i can access it from the server. please help. thanks
tristonyipAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

Vikas GargAssociate Principal EngineerCommented:
It is an access rights issue ...
If you are able to run the package from the Solution and unable to do it from SQL Job then the SQL agent owner should have rights to that folder/file.

If it is an error while running from SSIS DB manually it may be issue with the connection string of the flat file ...
tristonyipAuthor Commented:
yes, i ran it  from SSIS DB manually, it's the connection string issues from the error, but  i can not find any thing wrong  on the flat file connection string. it ran from my pc and from the server when i use SSIS. by the way, this package is from sql 2005 upgrade to sql2012, but i ran it from sql 2012 and deploy to the SSIS DB, thanks
Vitor MontalvãoMSSQL Senior EngineerCommented:
Isn't your user that need to have access but the SQL Server Agent service account since it's the credential that will be used.
Are the SQL Server Agent service account the same for both SQL Server 2005 and 2012?

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
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
Windows Server 2012

From novice to tech pro — start learning today.