Contact WVPASS for event and ticket information.

Looks like this event has already ended.

Check out upcoming events by this organizer, or organize your very own event.

View upcoming events Create an event

WV SQL User Group - Learning SSIS under 1 hour

Thursday, January 20, 2011 from 6:00 PM to 8:00 PM (ET)

Wheeling, WV

Ticket Information

Type End     Quantity
Free Pizza (with meat), Free Attendance Ended Free  
Free Pizza (without meat), Free Attendance Ended Free  
Free Attendance Ended Free  
SHARE THIS EVENT

Event Details

This will be the first official meeting of WVPASS (Wheeling, WV SQL Server User Group).  We will meet monthly on the third thursday of the month.

Agenda:

6:00pm to 6:15pm  - Network and eat free Pizza
6:15pm to 6:30pm  - Establish a few goals for the group and eat more pizza
6:30pm to 7:30pm  - The Main Event (Learning SSIS under 1 hour)

If you are interested in speaking, volunteering or sponsoring a future meeting send a message to our current fearless leader.

Title: Learning SSIS under 1 hour
Need to know what is the corresponding SSIS transformation or task to a specific T-SQL statement? How do you accomplish Unions, Joins, and Merges in SSIS? How do you do CASE statements in SSIS? How do you group and aggregate data in SSIS? In this session I will cover the some of the most important SSIS control flow and data flow tasks to jumpstart DBAs and Developers into SSIS with SQL Server 2008-R2. At the end of this interactive demo, you will be able to identify what control flow tasks and data flow transformations can be used in place of T-SQL statements and scripts. I will also cover how to accomplish in SSIS:
• Basic SELECT, INSERT, DELETE, UPDATE statements
• Inner and Outer joins
• CAST and CONVERT
• CASE statement • Sorting, Grouping and Aggregate functions (SUM, COUNT, MAX, AVG)
 • MERGE and Unions
• Loops (WHILE) and more
Bio:
Jose Chinchilla is a Microsoft Certified Database Administrator and Business Intelligence Developer working as a BI consultant for a Tampa based full service consulting firm. Jose has12+ years of experience in IT and has focused his career in OLTP and OLAP database design, development and administration and specializes in ETL/ELT, Data Warehousing and Multidimensional Analysis using SQL Server 2008 BI tools. He is also the current president of the Tampa Bay area Business Intelligence User Group and Official PASS Chapter. He is an avid twitterer under the @SQLJoe handle and blogs at http://www.sqljoe.com.

When & Where



2121 Main St
Orrick Building
WV Conference Room - 1st Floor
Wheeling, WV 26003

Thursday, January 20, 2011 from 6:00 PM to 8:00 PM (ET)


  Add to my calendar

Hosted By

WVPASS



The mission of the Wheeling SQL Server User Group is to provide an opportunity that will allow database developers, database administrators and all other IT professionals who work with databases to connect, share and learn for free. While everyone's shop might be unique the majority of the DBA's have similar projects and problems. We will allow all users the opportunity to share their experiences while they can also build their soft skills.