What specific problem/issues are you having?
It might help to see the log output for your DB Connect step in order to determine what is amiss. Be sure to change the IP, database name, user/password info in your connect string when providing a clip of the log.
Otherwise, here are a couple basics: * Use the DB Connect step * If you are using Windows Authentication, set your connect parameters to a connect string like this(change the IP/database name): DRIVER={SQL Native Client};SERVER=127.0.0.1;DATABASE=testdb;Trusted_Connection=Yes;MARS_Connection=yes * For SQL Server Authentication, set your connect parameters to a connect string like this(change the IP/database name/user/password): DRIVER={SQL Native Client};SERVER=127.0.0.1;DATABASE=testdb;uid=db_user;pwd=db_password;MARS_Connection=yes
|