I commented out a section in the code on how to use SQL Server Auth:

/* Setup connection, this is SQL Server authentication

ServerConnection conn = new ServerConnection();

conn.LoginSecure = false;

conn.Login = "YourUserName";

conn.Password = "YourPassword";

conn.ServerInstance = Dts.Variables["varServerName"].Value.ToString();

Server srv = new Server(conn);

*/

Just remove the trusted auth code and uncomment this section using the correct user name and password.