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: Thursday, December 1, 2016 3:10 AM
Points: 1,633, Visits: 2,645
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: Monday, November 28, 2016 10:34 AM
Points: 166, Visits: 599
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: Today @ 1:37 PM
Points: 7,981, Visits: 19,117
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.

If your posting includes some T-SQL code, please surround the code with IFCode formatting tags. It helps readability a lot.
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: Monday, November 28, 2016 10:34 AM
Points: 166, Visits: 599
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: Today @ 1:37 PM
Points: 7,981, Visits: 19,117
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.

If your posting includes some T-SQL code, please surround the code with IFCode formatting tags. It helps readability a lot.
Post #1444881
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse