Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

I have around 6+ years of experience in SQL Server development and in Business Intelligence area. I am working as Datawarehouse developer. My blog space includes all technical areas related to SQL Server and MSBI (SSIS, SSRS and SSAS).
Browse by Tags · View All
SSIS 7
xml 3
dynamic 3
Union All 3
SSRS 2
Data flow task 2
Buffer 2
Time 2
Date 2
varchar(max) 1

Archive · View All
February 2013 3
September 2009 3
June 2013 2
January 2013 2
November 2012 2
July 2012 2
July 2009 2
April 2013 1
December 2012 1
February 2010 1

Export to XML File using SSIS

Jun 13 2013 12:00AM by Divya Agrawal Shah   

Recently I was given a task to export data in XML format using SSIS. I initially thought it should be straight forward – just dump it in a flat file and give it a name xml type, however SSIS has no XML destination just an XML source. I had no luck dumping the XML in flat file. My solution was to use a script task which worked well.

My requirement is that the stored procedure would return the XML as a single row and I need to export that in a file.

Please visit the article posted on Sql-Server-Performance for the complete solution. Here, is the complete link

http://www.sql-server-performance.com/2013/export-to-xml-using-ssis/

Tags: 


Divya Agrawal Shah
89 · 2% · 629
2
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

2  Comments  

  • Hi Divya,

    In the above script why did you use PIVOT and what is mean by f.x.values,t.c.value what purpose we have to use this Requesting to you please explain.

    Regards siva

    commented on Jun 13 2013 7:24AM
    siva.meti
    1189 · 0% · 22
  • Hi Siva, In this post I have not used PIVOT anywhere. Sorry, but i am not sure which post you are referring. I think you are referring http://beyondrelational.com/modules/2/blogs/51/Posts/19513/convert-xml-data-to-sql-table-data.aspx post. If so, then you can read more about using x-query. In xquery we give an alias to the node and then refer in the main query, so f.x ant t.c are same. PIVOT is used so as to i can transform the data output from columns to rows to get all the values for one record in a single row.

    commented on Jun 26 2013 3:09AM
    Divya Agrawal Shah
    89 · 2% · 629

Your Comment


Sign Up or Login to post a comment.

"Export to XML File using SSIS" rated 5 out of 5 by 2 readers
Export to XML File using SSIS , 5.0 out of 5 based on 2 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]