Hello Friends, Can you please help me to schedule SSIS package on Sql server agent. I tried it as following ways but it showing me error while im trying to execute that job.Im trying to import flat file using SSIS package.

Hi , I think your issue should be raised in the SQL Server Integration Services. I believe they will know more information of this issue than us, and I will move this one to that forum. Thanks for your understanding, Best regards, JesseJesse Jiang [MSFT] MSDN Community Support | Feedback to us

Could you post the error which you get while executinmg the package.

The configuration seems correct. However, since the package is using the SQL Server Agent account, it could be a permission issue. Or, you are still using the default protection level (EncryptSensitiveWithUserKey), so the Agent can't load the package. Once we know the error, it will be easier to debug. (or when my crystal ball arrives, whatever comes first)MCTS, MCITP - Please mark posts as answered where appropriate.

Can you show us the error? Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Hello, Whats the error you are getting? Regards Satheesh

Hello, Whats the error you are getting? Ah. 4 people have now asked what the error is. We can play cards :)MCTS, MCITP - Please mark posts as answered where appropriate.