Skip to main content

15th Day

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</empno>
   <ename>bb</ename>
   <sal>1200</sal>
   <deptno>20</deptno>
  <emp>
  .
  .
  .
</employees>

* Save the file with coats as "Employee.xml".




 

Comments

Post a Comment

Popular posts from this blog

Lesson 57: Auto refresh the report in SSRS

                     How to Auto refresh the report in SSRS. Firstly create a datasource,dataset and select the required fields into the table/matrix. If you want to refresh the report frequently for every second you can change the Auto refresh as 1 in the properties of the report. If you want to change the color of a field after given period of time to change the expression of the color in properties as a follows and set the Auto refresh time to the required period of time in the report properties.
Post a Comment
Read more

12th Day

Conditional statement in SSIS: same as ternary operator in C ** <condition>? <true>:<false> Eg: Gender=="M" ? "Male": "Female" Multicast Transformation : This t/r creates multiple copies of i/p data. it is useful because every time we need not to go to source. ** This will improve task performance. Aggregate Transformation : It is used to convert the detailed values into aggregated data by using Aggregate functions like sum,avg,max,min,count etc. ** It is Asynchronous transformation. Example: to the i/p data from source group by deptno and perform aggregate funcs. Conversion in SSIS ; * Conversion is very important because data from flat file, excel comes to transformations in the form of string(varchar) , so we cannot perform required operations so it require to convert data. 1) Directly at source level : ** Select flat file source, right click--> show advanced editor. ** Select i/p & o/p properties tab, ...
Post a Comment
Read more

Lesson 67: Join two datasets in SSRS by using Lookup function

How to join two datasets in SSRS by using Lookup function First create two datasets each one with a different datasource. Next insert a table in the report body and insert the required columns from the dataset1. Next in order to insert the columns from 2nd dataset, you need to write a look up function where you need to give the matching columns from both the datasets and the required column from dataset and scope as 2 datset Here since we are inserting the columns of dataset1 first, we are writing exp with scope as dataset 2.
Post a Comment
Read more