Use the DataBaseInterface Designer. Attach to your DB, Point to your SP or write you query, build your type tree. Create your map using the DBID file & query as input, flat file as output and map away.
Should have a some instructions in the DBID PDF that should have shipped with tools.