Welcome to PC Teach Me...

Free Computer Training Videos.

Although you do not need to register to access this site. Registering has its benefits. Such as:

  • Access to training material associated with the video you are watching [if applicable]
  • Automatic email updates when new training videos are available.
  • Ask for a training video.
  • Exclusive access to pose questions to me [limited availability as I am doing this for free :-)].
  • Free contribution of your own training topics, this includes referencing your videos outside of PC Teach Me.
  • Its Free!

Member Login

Lost your password?

Not a member yet? Sign Up!

By registering with this blog you are also agreeing to receive email notifications for new posts but you can unsubscribe at anytime.

25425 Registered Users
71 Number Of Articles
Free Video Tutorials (Email) Free Video Tutorials (RSS) Free Video Tutorials (Twitter) Free Video Tutorials (Flickr)

SSIS: Conversion & Derived Data

Part of Microsoft Integration Services

ssis SSIS: Conversion & Derived DataSSIS: Conversion and Derived Data

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.

SSIS Tools For the Job

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.

This video is one of many SSIS tutorials on this site click here for more.

Example SSIS File

To download the accompanying SSIS files click here:

Related Posts

231 Comments

  1. Subhash Upadhyay says
    05 Oct 13 at 9:38am

    Very Interesting fact! Thanks for sharing

  2. Sean DeYoung says
    23 Aug 13 at 3:13am

    Super! Thanks!

  3. LuckyLbow says
    27 Feb 13 at 1:40pm

    Thanks, I ‘ll try to follow up as I am about to embark on a crazy SQL 2008 database build which has to be complete in a month from now .

  4. Kalpana Ganesan says
    10 Dec 12 at 1:20am

    Informatics Outsourcing is an Offshore Data Management service company. Data Management Service includes all types of Data Conversion, File Conversion, XML Conversion, HTML Conversion,SGML Conversion, Document Conversion,Data Entry, Data Extraction and Validation,OCR and ICR Services with affordable price. Our team to give the solution quickly and given requirements.

  5. segexvent says
    19 Oct 12 at 11:17am

    All I wana say is a BIG THANK U!

  6. Hussion joy says
    24 Sep 12 at 9:29pm

    Very nice video presentation about data conversion. Good Job keep it up.

    dataentryservicesonline. com

  7. padawan says
    02 May 12 at 1:01pm

    Legend 😉 These videos are fantastic.

  8. SoumyaRahul1985 says
    21 Feb 12 at 1:45am

    too good..thnx

  9. 21 Feb 12 at 1:45am

    [..YouTube..] too good..thnx

  10. PCTeachME says
    02 Feb 12 at 11:26am

    Thanks for your feedback, appreciate it!

  11. PCTeachME says
    02 Feb 12 at 11:26am

    [..YouTube..] Thanks for your feedback, appreciate it!

Leave a Comment

You must be logged in to post a comment.

Valid XHTML 1.0 Transitional website security