Login failure when running a SSIS package from a SQL Server job Yes, it is done in ODBC connection, and the test connection can be established successfully there, but I know know how force SQL Server job use that credential, e.g: userId = dba not the SQL server Agent user.