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

Unzip .gz file from network map drive and load into table (SQL 2012) Expand / Collapse
Author
Message
Posted Wednesday, November 20, 2013 10:53 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, December 14, 2014 3:10 PM
Points: 42, Visits: 165
Hi,

The aim of this exercise is to

- unzip the xml file (*.xml.gz file) from network map drive
- load into table (xml file) in xml column with name of the file in different column.


Can you please tell me what SSIS tools I can use to achieve this or some sample packages I can refer to.

Thanks for your help in advance.
Post #1516143
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse