I am trying to schadule a job on sql managment studio 2008.
the job will read from SQL and insert into SQL databas.
I setup an admin username "BIAdmin".
I deploy the package as a file system.dtsx when i double click on the system file its work perfect but when i schadule as a job on SSMS i goyt an error
Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E4D Description: "Login failed for user 'biadmin'.". End Error Error: 2011-08-04 13:14:22.25 Code: 0xC020801C