Posted: Sat Mar 12, 2011 7:43 pm
Once in a while sounds about right 
Thanks james i got itjwiles wrote:Click on the Output->Columns, then right-click on the generated column select Edit Row...
Generator->Algorithm
Choose your type. The algorithm types available vary depending on data type. For char/varchar and this job, I would choose Cycle and give it only one value to cycle through. The other type is Alphabet and you provide a string of characters for it to cycle through (again, for this job just enter one character). Other data types should be self-explanatory.
Regards,