TechNet
Products
IT Resources
Downloads
Training
Support
Products
Windows
Windows Server
System Center
Microsoft Edge
Office
Office 365
Exchange Server
SQL Server
SharePoint Products
Skype for Business
See all products »
Resources
Channel 9 Video
Evaluation Center
Learning Resources
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Script Center
Server and Tools Blogs
TechNet Blogs
TechNet Flash Newsletter
TechNet Gallery
TechNet Library
TechNet Magazine
TechNet Wiki
Windows Sysinternals
Virtual Labs
Solutions
Networking
Cloud and Datacenter
Security
Virtualization
Updates
Service Packs
Security Bulletins
Windows Update
Trials
Windows Server 2016
System Center 2016
Windows 10 Enterprise
SQL Server 2016
See all trials »
Related Sites
Microsoft Download Center
Microsoft Evaluation Center
Drivers
Windows Sysinternals
TechNet Gallery
Training
Expert-led, virtual classes
Training Catalog
Class Locator
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
Microsoft Official Courses On-Demand
Certifications
Certification overview
Special offers
MCSE Cloud Platform and Infrastructure
MCSE: Mobility
MCSE: Data Management and Analytics
MCSE Productivity
Other resources
Microsoft Events
Exam Replay
Born To Learn blog
Find technical communities in your area
Azure training
Official Practice Tests
Support options
For business
For developers
For IT professionals
For technical support
Support offerings
More support
Microsoft Premier Online
TechNet Forums
MSDN Forums
Security Bulletins & Advisories
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
Sign in
Home
Library
Wiki
Learn
Gallery
Downloads
Support
Forums
Blogs
Resources For IT Professionals
United States (English)
Россия (Pусский)
中国(简体中文)
Brasil (Português)
Skip to locale bar
Get this Tag RSS feed
Translate this page
Powered by
Microsoft® Translator
Popular Tags
Active Directory
AD
AD DS
adfs
ASP.NET
azure
BizTalk
BizTalk Server
BizTalk Server 2010
C#
Candidate for deletion
certification
cloud
core docs
de-DE
EAA
Ed Price
Ed's Stub Pages
en-US
ESA
es-ES
Excel
Exchange
Exchange 2010
fa-IR
Fernando Lugao Veltem
FIM
FIM 2010
FIM Resources
FIM-HELP
forefront
forums
fr-FR
Gokan Ozcifci
has code
has comment
has comments
has image
has Images
has Other Languages
has See Also
Has Table
Has TOC
Horizon_Net
How To
Hyper-V
id-ID
IIS
Italian Wiki Articles
it-IT
ja-JP
Jordano Mazzoni
Link Collection
Luciano Lima
Luigi Bruno
Lync Server 2010
MIISILMFIM MACAULAY
Multi Language Wiki Articles
needs work
operations manager
Pirated Content
Portal
Português Brasil
PowerShell
pt-BR
security
SharePoint
SharePoint 2010
SharePoint 2013
SharePoint Pirate
Small Basic
solucionando problemas
SQL Server
SQL Server 2012
stub
System Center
System Center 2012
TechNet Guru
TechNet Wiki
TechNet Wiki Featured Article
tonyso
Translated into Japanese
troubleshooting
tr-TR
vídeo
Video
Virtualization
VMM
Wiki
Windows
Windows 7
Windows 8
Windows Azure
Windows Server
Windows Server 2003
Windows Server 2008
Windows Server 2008 R2
Windows Server 2012
yottun8
اکتیو دایرکتوری
Browse by Tags
>
TechNet Articles
>
All Tags
>
SSIS transformations
Tagged Content List
Wiki Page:
SSIS: List of Transformations
prasadnimmani
When it comes to data processing, Integration Services reads data from various sources, and writes them to their destinations, but usually some transformation of the data is needed in the meantime (according to the requirements, of course). SSIS can transform the data using its own transformation components...
on
29 Aug 2013
Wiki Page:
SSIS Lookup Transformation
Naomi N
Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in Data Flow Tasks , between data source and destination components, or other transformations . The Lookup is a fairly popular transformation. Its reason is that using...
on
21 Jul 2013
Wiki Page:
SSIS Aggregate Transformation
Carsten Siemens
Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in [[articles:SSIS Dataflow Task|Data Flow Tasks]], between data source and destination components, or other transformations . In a BI environment, data consumers might not be interested...
on
28 May 2013
Wiki Page:
SSIS Multicast Transformation
Richard Mueller
Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in Data Flow Tasks , between data source and destination components, or other transformations . Sometimes the data flow must be processed in a detailed and an aggregated way, or different...
on
8 Apr 2013
Wiki Page:
SSIS Conditional Split Transformation
Richard Mueller
Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in Data Flow Tasks , between data source and destination components, or other transformations . The Conditional Split transformation is a fairly simple one: based on the condition set defined...
on
8 Apr 2013
Wiki Page:
SSIS Sort Transformation
Richard Mueller
Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in Data Flow Tasks , between data source and destination components, or other transformations. The Sort transformation basically has only one task: to put the incoming rows in a specified...
on
5 Apr 2013
Wiki Page:
SSIS Merge Join Transformation
Richard Mueller
Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in [[articles:SSIS Dataflow Task|Data Flow Tasks]], between data source and destination components, or other transformations . Combining data from separate sources is quite often...
on
5 Apr 2013
Wiki Page:
SSIS Pivot Transformation
Ed Price - MSFT
Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in [[articles:SSIS Dataflow Task|Data Flow Tasks]], between data source and destination components, or other transformations . There are many cases (for example, in reporting), when some...
on
12 Oct 2012
Wiki Page:
SSIS Pivot transzformáció (hu-HU)
Ed Price - MSFT
Az ETL adatfolyamokban az Integration Services transzformációkat használ az adatok manipulálására. A transzformációkat a Data Flow Task-okban használhatjuk, adatforrás- és célkomponensek, illetve más transzformációk...
on
12 Oct 2012
Wiki Page:
SSIS Audit Transformation
Tomoaki Yoshizawa
Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in Data Flow Tasks , between data source and destination components, or other transformations . In some cases the ETL process is required to be audited. This means that data must contain...
on
20 Sep 2012
Wiki Page:
SSIS Percentage Sampling Transformation
Zoltán Horváth
Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in Data Flow Tasks , between data source and destination components, or other transformations . Sometimes the source data has large volumes, and during development, less rows would be...
on
5 Sep 2012
Wiki Page:
SSIS OLE DB Command Transformation
Zoltán Horváth
Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in Data Flow Tasks , between data source and destination components, or other transformations . Creating data-driven ETL process es is not unusual during a data warehouse implementation...
on
5 Sep 2012
Wiki Page:
SSIS Row Sampling Transformation
Zoltán Horváth
Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in Data Flow Tasks , between data source and destination components, or other transformations . Sometimes the source data has large volumes, and during development, less rows would be...
on
5 Sep 2012
Wiki Page:
SSIS Character Map Transformation
Zoltán Horváth
Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in Data Flow Tasks , between data source and destination components, or other transformations . Alphanumeric values are often need transformation during a data flow: converting to upper...
on
5 Sep 2012
Wiki Page:
SSIS Merge Transformation
Zoltán Horváth
Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in Data Flow Tasks , between data source and destination components, or other transformations . Sometimes sorted data flows can be a key requirement, especially before joining data with...
on
5 Sep 2012
Wiki Page:
SSIS Script Component Transformation
Zoltán Horváth
Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in Data Flow Tasks , between data source and destination components, or other transformations . ETL developers sometimes face requirements which cannot be solved with the built-in transformations...
on
5 Sep 2012
Wiki Page:
SSIS Derived Column Transformation
Zoltán Horváth
Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in Data Flow Tasks , between data source and destination components, or other transformations . Data usually must be transferred after replacing the values in some columns, or a new,...
on
5 Sep 2012
Wiki Page:
SSIS Row Count Transformation
Zoltán Horváth
Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in Data Flow Tasks , between data source and destination components, or other transformations. The Row Count transformation simply counts the records flowing through a data path. It only...
on
5 Sep 2012
Wiki Page:
SSIS Union All Transformation
Zoltán Horváth
Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in Data Flow Tasks , between data source and destination components, or other transformations. There are situations when data from multiple but similar sources must be combined into a...
on
5 Sep 2012
Wiki Page:
SSIS Unpivot Transformation
Zoltán Horváth
Integration Services uses transformations to manipulate data during an ETL dataflow. Transformations can be used in Data Flow Tasks , between data source and destination components, or other transformations . The Unpivot transformation can help in normalizing of a dataset during the load process of...
on
5 Sep 2012
Page 1 of 1 (20 items)
Can't find it? Write it!
Post an Article