Interacting selectively and non-covalently with a DNA-dependent core RNA polymerase to form a holoenzyme complex and also, while present in the holoenzyme, interacting with promoter sequences in order to confer sequence specific recognition of promoter DNA sequence motifs.