SSIS - Data Conversion & Derived Data

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
9,627
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Jul 23, 2010

With any data that your going to import into a database there are problems with the way the data has been entered down to calculations displaying values to too many decimals.

To correct this you need to look at cleansing the data. this can be done inside the source data itself. I.e. fix the data within Excel or SQL first. More often than not you cannot change the source data and instead need to "convert" it to the destination.

So how is this done you may ask? Well with SSIS you can use two components specifically designed for this job. These are:

Data Conversion
Derived Column

I don't know about you but they sound the same don't they? Well in fact they are very different. How? well lets watch the video and find out!

As this is a lightening quick tour of these data flow tasks you may find it helpful to download the example files I use in this video. They can be obtained from my website PCTeach.me

  • likes, 0 dislikes

Link to this comment:

Share to:

Uploader Comments (PCTeachME)

  • awesome

  • @christosch Thanks for your feedback, appreciate it!

  • thx alot!

  • @Donder1337 No Problem glad I could help

  • Great Presentation.I was trying to make work one of my first packages i.e to load from multiple flat file sources to an oledb destination and it worked finally using the data conversion and derived column transformations.

    Thanks Much

    I would like to see more videos from you to help beginners on variables and expressions.Please continue your good work

  • @vamsikiran333 Hi, thanks for the feedback. There are two videos, on my channel which goes into variables. Please post some comments on there if you wish to know more

see all

All Comments (12)

Sign In or Sign Up now to post a comment!
  • too good..thnx

  • Informatics Outsourcing is an Offshore company providing Data Conversion service Worldwide with affordable price.

  • Very precise video...looking forwad for many such video's...

    Thanks

  • I am just starting to learn ssis & your video's are very clear & concise even for beginners. Thanks for posting. I am sure there are more video's on yr website for SSIS.

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more