Floating FB popout byF5debug

SQL Server Integration Services (SSIS) – Part 41 – Copy Column Transformations in SSIS

 

This is part 41 of the series of article on SSIS

Introduction:

In this article we are going to see on how to use the Copy Column transformation inside a package. Copy Column task help to copy a column to a destination as and when required to have sync across the environments. Let’s jump start to the section on how to do that using a sample package.

You can look into my series of article on SSIS at the url - http://f5debug.net/tutorial/ssis.aspx

[more]

Steps:

Follow steps 1 to 3 on my first article to open the BIDS project and select the right project to work on integration services project. Once the project is created, we will see on how to use the Copy Column control. Once you open the project just drag and drop the Copy Column control and a source and destination OLEDB provider control to get and update the column as shown in the below screen.

clip_image001

We have configured the OLEDB Source to fetch the data which we are going to make a copy. Now lets configure the Copy Column as shown in the below screen

clip_image002

Clicking on OK will do the configuration of the copy column control. Now go to the OLEDB Destination control and configure to the correct Column as shown in the below screen

clip_image003

Once we are done with the configuration Press F5 to build and execute the package. Once the package gets executed successfully your screen looks like below

clip_image004

Conclusion:

So in this article we have seen on how to use the Copy Column to transform a copy of column to the destination for particular columns in a table.

About Author: Karthikeyan Anbarasan, Microsoft MVP (Most Valuable Professional) in ASP.NET/IIS Architecture. He is the Founder and Chief Editor of the www.f5debug.net website and has authored books on Windows Phone and Business Intelligence(SSIS). He is also a Passionate Speaker and a Blogger on Microsoft Technologies.

You can Join Me On: Facebook, Twitter, Google Plus, LinkedIn

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Recent Posts

Random Posts

Most Viewed

URL Shortner

Create your own short urls!!!

Site Counter

free counters

Disclaimer

This is a personal weblog. The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet. I have documented my personal experience on this blog.

Protected by Copyscape Web Plagiarism Finder

Site Meter