Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

Multiple Ole db sources to a single flat file destination Expand / Collapse
Posted Tuesday, February 19, 2013 11:33 AM



Group: General Forum Members
Last Login: Today @ 8:30 AM
Points: 6,131, Visits: 14,958
sunder.mekala (2/19/2013)
Just to make calrify, my requirement is i have 5 ole db sources that i have load it into a SINGLE flat file

why 5 ole db sources?

As i dont have any relation between the tables (they are just logging tables) i have to go for 5 different ole db sources (sql server tables with different columns in each table).


What is wrong with my proposed solutions?

Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.

I had some words with my wife, and she had some paragraphs with me.
Post #1421790
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse