How to map the output of OLE DB COMMAND to the flat file destination

• conningtower

  Say Hey Kid

  Points: 675

  More actions

  September 28, 2009 at 3:01 pm

  #136313

  Hi All

  The OLE DB Command executes a select statment . Could someone pls tell me how I can get the output of that in a flat file .

  Thanks

• Erik Kutzler

  SSCarpal Tunnel

  Points: 4287

  More actions

  September 29, 2009 at 7:16 am

  #1059446

  Place a Flat File Destination in your Data Flow task.

  Click on your OLE DB Source. See the green arrow? Drag & drop it onto the Flat File Destination.

  Double-click on the Flat File Destination and set up the Connection Manager & Mappings.