SQLServerCentral: Content tagged T-SQL, ETL

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,079 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,364 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,237 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,423 reads

Content with tags T-SQL, ETL

T-SQL insert using SSIS Data Pump

Merge, Metadata and the Data Mart ETL

Import Excel Spreadsheet to Database Tables

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