Click here to monitor SSC
SQLServerCentral is supported by Redgate
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 @ 1:56 PM
Points: 7,775, Visits: 18,704
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.

Just when you think your code is idiot-proof, the world invents a better idiot.
Post #1421790
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse