JR's Blog | All posts tagged 'SSIS'

Why SSIS configuration is Rocket science?

by Jean-Rene Roy 17. November 2010 09:20

When I stated to use SQL Server Integration Services (SSIS) I thought it was easy until I had to setup a test, prod and a Dev environment.  The configuration in SSIS is all over the place and even if you are an expert, you still look many places to find what you what to configure.   

This is why I design this session call: Why SSIS configuration is Rocket science?

Learning SQL Server Integration Service (SSIS) is not that difficult but the deployment in production is. Why? Because SSIS package Configurations is Rocket Science. This session will present many examples of SSIS configuration and show you the pit fall, tips and tricks and best practices for SSIS. This session is not just for the DBA but also for the developers. Attending this session can save you many frustrations. You need to see it.

Come and see me at the OttawaSQL.Net meeting.

Date: Nov. 18th (Thursday night)

Location: 100 Queen 5th floor

Arrival: 5:45pm

 

Tags:

.NET | Event | SQL

Speaking on SSIS next week at Ottawa TechDays

by Jean-Rene Roy 5. November 2010 09:13

Next week (Nov. 9th at 10:00am) I will be speaking at TechDays Ottawa in the Local Flavours track.  I originally name the session. “Why SSIS configuration is rocket sciences” but for TechDays we change the title to:

SQL Server Integration Services Tips and Tricks

Learning SQL Server Integration Services (SSIS) is not that difficult but deployment of packages can be challenging. This session will present many examples of SSIS configuration and show you tips & tricks as well as best practices for SSIS. This session is not just for the DBA but also for the developers. Attending this session can save you many frustrations. You need to see it.

Anyway, I prepared 10 demos to get my Point(s) about SSIS configuration and if you work with SSIS, this session is not to be missed.

Tags:

.NET | SQL

Jean-Rene Roy Bio

Jean-René Roy has been developing IT systems for large and small enterprises since 1987. In 1991 he founded the consulting firm Technologies SoftDesign Inc.

Since that time he has worked on projects for Bell Canada, CGI, ArchiDATA, Keops, House of Communes, Kraft, Innovapost and many other clients assuming the responsibility of Software Developers, Analyst, Team leader, Software architect and mentor. He has been and is still very active in the developers’ community by acting as a user group leader for more than ten years with the Montreal .NET community and the Ottawa .NET community.

He is also the co-founder of an international developer’s conference www.DevTeach.com which is now directed by a member of his team. Jean-René Roy is a SQL Server Microsoft MVP.

 

 

Month List

Page List