.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Sandeep Singh

Home >> Articles >> DataBase >> Post New Resource Bookmark and Share   

 Subscribe to Articles

Data Conversion Transformations in SSIS - SQL Server Integration Services (SSIS) - Part 42

Posted By:Karthikeyan Anbarasan       Posted Date: May 01, 2011    Points: 200    Category: DataBase    URL: http://www.dotnetspark.com  

In this article we are going to see how to use the Data Conversion transformation inside a SQL Server Integration Services (SSIS) package



In this article we are going to see how to use the Data Conversion transformation inside a package. A Data Conversion task is mainly used in large transformations where the data compatibility should be checked in order to update back to the database. Say for example we get some daily morning loads as some file and in that file we can see some data type errors which needs to be altered from string to integer; in that case this task can be used. Let's jump start to the section on how to do that using a sample package. 

You can also read my other articles on SSIS from here. 


Follow steps 1 to 3 on my first article to open the BIDS project and select the right project to work on an integration services project. Once the project is created, we will see how to use the Data Conversion control. Once you open the project just drag and drop the Data Conversion control and a source and destination provider as shown in the image below. 

Here we are using a Flat file data source which has 3 columns as strings. Out of the 3, we need to convert the data type of 2 columns. Let's see how to do that using this sample. Double-clicking the Data Conversion control will open a window to do the configuration. Follow as shown in the image below. 

Here we can select the data type based on our need, like we can select a Currency Data type if an amount field is found. Now click on the OK button to complete this step. Now we need to drag and drop a destination file task and configure as shown in the image below. 

Now press F5 to run the task and you can find the data type converted. To have it used in real time we need to use it to update the database where it has constraints on having only numeric or a string based on the business.


So in this article we have seen how to use the Data Conversion Transformation to transform a data of different type.
 Subscribe to Articles


Further Readings:


No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend