Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags T-SQL, ETL Rss

   Items 1 to 4 of 4   
 

T-SQL insert using SSIS Data Pump

This article describes a T-SQL procedure to insert data using the SSIS Data Pump  Read more...
By Federico Iori 2013/02/05 | Source: SQLServerCentral.com | Category: bulk insert
Rating: |  Discuss |   Briefcase | 7,366 reads

Merge, Metadata and the Data Mart ETL

Here's a great method for managing ETL for data marts and small data warehouses with just T-SQL.  Read more...
By Christopher Ross 2012/12/27 | Source: SQLServerCentral.com | Category: etl
Rating: |  Discuss |   Briefcase | 4,504 reads

Import Excel Spreadsheet to Database Tables

Importing Excel Spreadsheets is something that we often do with SQL Server. However it's not as easy as you would like as we move to the 64 bit platform. Peter He brings us a method that will work on all platforms.  Read more...
By Peter He 2010/02/17 | Source: SQLServerCentral.com | Category: etl
Rating: |  Discuss |   Briefcase | 17,533 reads

Using T-SQL to Transform XML Data to a Relational Format

More and more data is being stored or transmitted in an XML format. New author Nasir Mirza brings us an article that examines how to transform a number of XML structures into different relational formats for storage in SQL Server.  Read more...
By Nasir Mirza 2009/12/30 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 11,658 reads
   Items 1 to 4 of 4   
 
Tags
bulk insert (1)    
business intelligence (1)    
data mart (1)    
data pump task (1)    
excel (1)    
integration services (ssis) (1)    
merge (1)    
metadata (1)    
xml (1)