what Transformations have you
done; give specific examples:
Although there are so
many transformations available in SSIS but most often I used Conditional
Split to filter the data, Data Conversion to change the data type of the
source ,Derived column to add a new column and change the existing column by
using expressions, Lookup to find out the match data and unmatched data between
source table and destination table, Merge to merge the two data sources , Merge
join to join the two tables, Multicast to distributes its input to one or
more outputs, OLEDB command to write sql code , Row count to count the rows of
the source table, script component to write a C# code, sort to sort the source
table and Union All to union more the two datasource tables .
No comments:
Post a Comment