SSIS - Data Conversion & 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.

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

Category:

Education

Tags:

• BI
• Business Intelligence
• Data Conversion
• Data Conversion Task
• Derived Column
• Derived Column Task
• Excel
• Microsoft SQL
• SQL
• SSIS
• SSMS
• convert data
• convert
• data flow
• control flow
• Microsoft
• BIDS
• training
• tutorial
• teach me
• Instructions
• Microsoft SQL Server

[christosch]

awesome

[PCTeachME]

@christosch Thanks for your feedback, appreciate it!

[Donder1337]

thx alot!

[PCTeachME]

@Donder1337 No Problem glad I could help

[vamsikiran333]

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

[PCTeachME]

@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

[SoumyaRahul1985]

too good..thnx

[kalpanaganeshm]

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

[rahulsahay321]

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

Thanks

[agpta1900]

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.