My Tech Views

Raw Files T/r : * Raw files generally contains some random structure and has more performance compared to   flat files. Only SSIS supports raw files. * Raw files are not directly available, so for our example first let us create a raw file source using a    raw file destination and later using that file as source we do another example. * Take a oledb source and link it to raw file destination and create a raw file. later use that file as    source. Xml Source : * SSIS supports only xml as source but not as destination. * If there is a xml file try with that file as source, if not create a xml and try the example. Creating xml file : <employees>   <emp>    <empno>101</empno>    <ename>aa</ename>    <sal>1000</sal>    <deptno>10</deptno>   </emp>   <emp>    <empno>102</empn...

Merge Join T/r : * This t/r is used to join 2 sources with dissimilar structures based on a joining condition. *Difference between merge and merge join is 1) Here M-J joins sources with dissimilar structures. 2) Both t/r's should have at least one  common column and that in sorted order and of same datatype 3)Here we can implement inner join , left join , right join. Ex: Take a flat file source and table as emp , oledb source table as dept , convert the dno column into same datatype and give the o/p's of sources  to sort t/r and from sort to merge join, to at last oledb destination. Audit T/r : * It adds some new column's like package name, task name, machine name, user name and execution time as o/p to the available i/p columns. Ex: Try with a flat file source, link it to audit t/r. Row Sampling and Percentage Sampling T/r : * This t/r is used to generate specified number/percentage of random records from the sour...