The part you need is called a downpipe.
The flex pipe is connected to the downpipe.
The downpipe is supposed to be included with the header along with gaskets and bolts.

Here's a pic of my stainless steel Megan header when I got it.