Advanced Topics in SQL Server 2005 SSIS (Presentation)

by Allan Mitchell 15 Oct 2007 14:00

Download the slides and sample code from the Advanced Topics Using Microsoft SQL Server 2005 Integration Services presentation, first presented at the SQLBits 2007 Community Conference.

In this session we looked at some of the not so often thought about areas of the SSIS toolbox. Perhaps they aren't considered true ETL by some people or are simply not seen but we think they are really useful weapons in our ETL armoury. Highlights include:

  • Loading partitions directly
  • Consuming a package in SSRS
  • Using a DM algorithm in the pipeline to see if the new customer meets criteria
  • Performance tips and tricks

Presentation & Samples (410KB) Advanced Topics in SQL Server 2005 SSIS - Solution and Scripts.zip

Sample Database (15MB) Advanced Topics in SQL Server 2005 SSIS - Database Backups.zip

Comments (2) -

5/23/2010 12:26:23 PM #

Sunil sharma

Its really helped me to work on SSIS.

Sunil sharma India

12/31/2010 8:37:20 AM #

Ramkumar

I am having a good knowledge in oracle, Now i am in sql server.

Ramkumar India

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Widget Amazon Book not found.

Object reference not set to an instance of an object.X

RecentComments

Comment RSS