While working with SSIS 2008 recently, I needed some random data. I found this:
http://www.sqlis.com/post/Data-Generator-Source-Adapter.aspx
From their webpage:
It generates random integer (DT_I4) and string (DT_WSTR) data and places them in the pipeline. You specify how many columns of each you would like and for any string columns you pass a fixed length value. You then need to specify how many rows in total you require to be generated.
