Running SSIS Package using a scheduled Job in SQL 2005   

Hi, I have created a SSIS package. The connection used in the SSIS is SQL 
Authenticated. This runs perfectly when executed even after it is deployed. 
However, I face problems when I want to execute this package as a job. The 
error I get is - "Login failed for user - <user name>".

While creating a step as part of the job, if i select the "Package Soruce" 
as "SSIS Package Soruce", then the SQL Authentication option is disabled. I 
am forced to use Windows Authentication.

However, I have noticed that if I use Windows Authentication through out, 
i.e. when i create the connection within SSIS Package, while deploying the 
SSIS package and while creating the step in the Job, all goes fine. 
Unfortunately, this is not what i want. All the connections should be SQL 
Authenticated as against Windows Authentication.

Please help! Thanks!
Manjunath Basrur

date: Mon, 22 May 2006 23:51:02 -0700   author:   Manjunath Basrur