No new comments.
View All Comments
No new messages.
View All Messages
No new notifications.
View All Notifications
LEARN: Introduction to Entity Framework
An Interview Question
Ask a Question
C, C++, MFC
Coding Best Practices
Universal Windows Platform
VR and AR
Databases & DBA
Design Patterns & Practices
Internet & Web
Internet of Things
Request a new Category
SQL Server Integration Services (SSIS) - Export Column Transformations in SSIS
In this article we are going to see how to use the Export column transformation in SSIS packaging. The Export column transformation task is used in cases where we need to read the data from the data flow in the package and save the information to a file. Say for example if we want to get some information of a product or an order to be saved in a file, like product image for sending mail to the user we can use this task. Unlike the other transformations this task does not require a destination task to create a file. 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 -
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 Export Columns control. Once you open the project just drag and drop the Export Column control and a source provider as shown in the below image.
Now configure the source provider by mapping to the correct database and the table as shown in the below screen:
Now we need to configure the Export Column task, to configure double-click on the control; that will open the window as shown in the below screen.
Here we have option to select the column where the path to be places as. You can also find checkboxes at the right side.
â€“ Will create a new file and add the data to the end of an existing file
â€“ Will overwrite the file if it already exists.
Now once the package creating is completed, press F5 to start the build and the execution of the package. Once the package is executed you can find the screen as shown in the below image
So in this article we have seen how to use the Derived Column Transformation to do some manipulation and transform data to a new column.
Column Transformations in SSIS
Export Column Transformations in SSIS
SQL Server Integration Services
Transformations in SSIS
What's New In Visual Studio 2017
Learn MongoDB Step By Step
Experience The New Features In Visual Studio 2017
Visual Studio 2017 New Features
Basic Information And Overview Of Visual Studio 2017
Basics And Overview Of ASP.NET MVC Core or MVC 6 In Visual Studio 2017
Learn Basics Of MVC Using AngularJS
Introduction To Azure Machine Learning Studio
Basic Operations In SharePoint 2013 Using PowerShell