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

load multiple xml file into a single flat file destination Expand / Collapse
Author
Message
Posted Friday, April 19, 2013 6:18 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 4:33 AM
Points: 1,556, Visits: 2,559
Good point Phil. Probably neater to do it that way (and no need for any scripts).
Post #1444345
Posted Monday, April 22, 2013 1:04 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, July 20, 2016 1:24 AM
Points: 150, Visits: 552
i've tried creating a static output file but now only one file is loaded in the the destination
Post #1444876
Posted Monday, April 22, 2013 1:10 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:36 PM
Points: 7,278, Visits: 17,648
Have you configured the output as 'Append' or 'Overwrite'?

If only the final file is appearing in there, I would suspect 'Overwrite'.



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.

Never attribute to malice that which is adequately explained by stupidity
Post #1444877
Posted Monday, April 22, 2013 1:15 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, July 20, 2016 1:24 AM
Points: 150, Visits: 552
YOU ARE SUCH A STAR
thank you so much i didn't realize i was overwitting the ouput, it works perfectly now!!!!!
Post #1444879
Posted Monday, April 22, 2013 1:17 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:36 PM
Points: 7,278, Visits: 17,648
Great - thanks for that!


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.

Never attribute to malice that which is adequately explained by stupidity
Post #1444881
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse