You can use DAQmx Write in a loop to generate a sine wave one sample at a time. If you want to control the timing, you can use "Wait for Next Millisecond Multiple" or you can use the LabVIEW timed loop.
However, I wouldn't recommend using the 6008 to output a sine wave.
Since every sample you write has to go over the USB bus individually, there will be a lot of variability between each update. The USB 1.1 bus has high latency; a minimum of 1-10 ms per message written. I expect you will be able to update the device once every 1-50 ms or so, but the exact time per update can vary considerably. Because of the variation, the sine wave will be extremely jittery. In addition, because of the slow update rate using USB, you won't be able to output more than 100-1000 samples a second. You will end up having to output a _very slow_ sine wave or output a very bad approximation of a sine wave.