Example for my question:

Select f1, f2, f3,......, c1 = 'ART'

from table1.......

where .........

to text file 1

Select f1, f2, f3,......, c1 = 'MUSIC'

from table1.......

where ........

to text file 2

There are many lines in...

Not sure about the specifics for the AS400, but I created a "SQL command from a variable" and then use Script Component to create the SQL command. The Script Component...

Yes sorry , that's what I meant, SQL Server Enterprise 2005, on Windows 2003 server x64, with all the latest patches. It's also on a cluster. I've been pulling my...