Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Katie and Emil

We are Katie & Emil and together we have decided to learn more & more on how to build data warehouses using Microsoft products. The best option to learn is to teach so we write tutorials and share it with others.

SSIS Webinar in 3 days... 6 seats left

Our first SSIS 1h Free webinar will take place in 3 days (Thursday) and has only 6 seats left (out of 25)

This webinar covers America and Europe (evening) time and the same webinar will take place on Saturday 23rd of February (Asia, Australia and Europe Time).

Who is it for? Anyone who is it comfortable using SSIS Transformations and would like to learn more.

Webinar title: SSIS Transformation Pitfalls.

Agenda:

Lookup Transformation - Case sensitive or case insensitive and why it matters.

Sort and Match - We have SQL Server and Windows and that causes issues when it comes to SSIS. We will give several examples.

Conditional Split - True and False but what about NULL? and ELSE?

SLOW, SLOW, SLOW - Blocking, semi-blocking and non-blocking transformations. Is blocking component really a problem?

SSIS is memory based - Will show you how to detect if disk is used instead of memory and how your package can fail if you do not have permissions to write to disk.

Slowly Changing Dimension Transformation - Good idea but Microsoft blew it! In here I will show alternative approaches.

Thinking of attending?

Eventbrite - SSIS Transformation Pitfalls

Take care
Katie and Emil

Comments

Leave a comment on the original post

Loading comments...