SSIS Tutorial with Videos

My Learning: Log in Learning Report [Log in]

Remove Ads or Log in
Remove Ads or Log in
+3  |  -0

Mini Learning Map

Welcome to our SSIS Tutorial from beginner to expert. Here we will show you step by step how to perform common tasks  using SSIS and cover more advanced topics as well.

Remove Ads or Log in

We need you!

By becoming a proud member we can:
  • Switch off annoying ads
  • Create more articles and videos
  • Develop more useful features supporting your learning
  • Provide FREE webinars (for members)
  • Feel our hard work since 2011 is appreciated
Become a proud member and get exclusive features.

If 2% of our 64,943 visitors (Last 30 days) become a proud member than we can quit our jobs and work full time on this website. We started membership in May 2014 and so far 0.07% of our visitors are members and we would like to say THANK YOU to those who become a proud member and support our efforts.

Thanks to members:
  • Education is for FREE and we create more FREE articles and videos
  • We provide new features (members) that can speed up learning.
  • 53% of our page views (82,000 each month) do not have page ads.
  • We switched video ads from 14% of our videos (50 out of 345).
We have invested 4 years of our time in this website and we estimate it will take about 5 years before we can quit our jobs and dedicate all our time to develop considerably our website which should help to truly achieve our vision of free education for everyone; all thanks to support of our members only. Become a proud member

Visitor Voting

Did you know we have over 340+ FREE Videos?
(Mainly T-SQL, SSIS, SSRS)
Visitor Voting: Yes +11  |  No -5
Add comment (no email required).

Add Comment
Name: jigar vora
Date Posted: 10/30/2012 1:50:48 PM

Wonderful job guys ....God Bless both of you ...keep rocking :) :)

Name: venkat
Date Posted: 11/15/2012 11:57:21 AM

diffrence b/w dataconversion and derived column

Name: Emil
Date Posted: 11/17/2012 7:05:02 AM

Hi Venkat,

The difference is that Data Conversion Transformation is a component on its own doing just data conversion and believe you can "replace" column with new data type where is with Derived Column you should be able to do that. 

Personally I rarely use Data Conversion Transformations and prefer to do it at source or using Derived Column.



Name: Mark
Date Posted: 4/12/2013 1:23:45 PM


I was struggling with resolving an issue with precedence constraints and your no 4 video provided the answer.

Excellent and thanks very much



Name: Tagur
Date Posted: 5/6/2013 1:17:39 AM

Hiii Katie and Emil,

    I am trying to load the data from a flat file to sql server database and I am getting status type 4 error. And I am pretty much sure that it is showing the error on the column "Created" which has the content as "2013 - 05 - 02 16:03:34".

I have even cross checked the datatype, allocated size and also tried to convert using DT_DBTIMESTAMP2 & DT_DBTIMESTAMP & also DT_DBTIME. But none of them is working. When I take of this column from the flat file and try to load the data, its working fine. Can you give me any suggestions on this.

I appreciate for your valuable time. Thank You

Name: Emil
Date Posted: 5/6/2013 4:53:58 PM


Try to set the data type (text file connection) to string 50 and also import using excel to see if there is anything unsual in the values for this column. 

Also you might be getting several error messages and one of them should be more descriptive.

Take care


Name: Dark Knight
Date Posted: 5/28/2013 12:58:41 PM

worth discoveirng your website and tutorial ....... please update all  flavours of sequel starting from sybase , oracle , db2, mysql & mssql ....etc

Name: Aldearan
Date Posted: 7/10/2014 11:15:18 PM
Comment: Very good tutorial video series! Simple examples with good tempo - this is it. Best Regards, BTW Are You come from Poland ?

Name: Emil
Date Posted: 7/18/2014 1:31:50 PM
Comment: Hi Aldearan, I'm glad to hear you like it and yes we are both from Poland and live and work in UK. Take care Emil

Are you a member?

If yes than please log in

Learning Map is for members with Bronze, Silver and Gold Membership.
For more information visit membership options.

Close this window , log in or learn more about membership benefits
  Become a Proud Member