Search  
Thursday, November 20, 2008 ..:: Home ::..   Login
 Sponsors Minimize

Idera Free Tools
 Print   
 Special Offers Minimize

Subscribe to MAKE and save!
 Print   
 Welcome Minimize

 Welcome to the SQL Server Innovators Guild (SSIG) site. 

Our group meets the 1st Tuesday of each month at ECPI in Greenville, SC. 

 

 

October 11th, 2008 at ECPI Greenville, SC

Register Now

 
 Print   
 News Minimize

Current Articles | Categories | Search | Syndication

Saturday, April 22, 2006
April 4th Meeting Notes
By pwaters @ 3:17 AM :: 1298 Views :: 1 Comments :: :: Meetings 		 
The ETL system I presented was a combination of techniques, naming conventions, processes, applications and reports from the different sources listed below, some that I cannot remember were I learned them, and maybe even something I actually thought of myself.

ETL Process and Naming Conventions
http://www.sqljunkies.com/WebLog/macaw/archive/2005/06/21/15889.aspx
Microsoft SQL Server BI Metadata Samples
http://www.microsoft.com/downloads/details.aspx?FamilyID=11daa4d1-196d-4f2a-b18f-891579c364f4&DisplayLang=en

SQL Server 2005 Integration Services Log Reports
http://www.microsoft.com/downloads/details.aspx?familyid=D81722CE-408C-4FB6-A429-2A7ECD62F674&displaylang=en

Custom Package Logging

"The Microsoft Data Warehouse Toolkit" Chapter 6
http://www.amazon.com/gp/product/0471267155/sr=8-6/qid=1145384940/ref=pd_bbs_6/104-2527065-9468725?%5Fencoding=UTF8

Samples can be downloaded at http://www.msftdwtoolkit.com/

Links about some of the other SSIS features used.
Configurations
http://blogs.conchango.com/jamiethomson/archive/2005/11/02/2342.aspx
Templates
http://support.microsoft.com/?kbid=908018

Best Practices
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/SQL05InSrREAL.asp
http://www.microsoft.com/technet/prodtechnol/sql/2005/realetldp.mspx
http://blogs.conchango.com/jamiethomson/archive/2006/01/05/2554.aspx
Since the meeting I have started to use expressions to create more powerful templates and reduce the opportunities to really mess things up. To find out about expressions search SQL Books Online (BOL)
Comments
By Anonymous @ Thursday, April 27, 2006 11:26 AM
Thanks for making this available.
Click here to post a comment
Syndicate   Print   
 Affiliate Groups Minimize

Culminis.com

 
 Print   
 Favorite Links Minimize
 Print   
Copyright (c) 2008 SQL Server Innovators Guild   Terms Of Use  Privacy Statement