Didn't think to use the DTS package, although I was hoping find some simple method (programatically). Thanks for your input.

I can currently use the SET ROWCOUNT to get what I need but it still prevents me from doing this in Enterprise Manager unless I change the SQL statement each...