We’re trying to read data from a MS SQL DB. Is that possible? If so, how do you do it? As a suggestion might be good to have documentation on this in the online docs…Thanks!
You can definitely use the DB Reader Operation (just search “db” in the toolbox). When you add it to your task, it will ask for a number of params. For MS SQL use the following:
Driver = net.sourceforge.jtds.jdbc.Driver
Connection string = jdbc:jtds:sqlserver://SERVERNAME:PORT/DATABASE