Skip to main content

7th day

SSIS Designer:

** Packages are developed using 2 ways the one is through SSIS wizard and second is through Designer.

* In SSIS wizard process we create packages in Import and export data tool, Here we create packages using SQL server data tools.

* Using Wizard we can develop only simple packages but by using Sql server data tools complex packages can be developed in accordance to required business logic.

* Start--> SQL server data tools or open run --> devenv

* Select new project and project type as integration services for SSIS application development.

* New project contains different windows--

 1)Solution explorer: Many projects can be made under one solution and using this we can easily             navigate through projects and under the projects contains packages

2)Tool Box: It contains items placed in the SSIS package.

** Items can be Control flow(tasks and containers) , Data flow(source, transformation, dest)

3) Properties window: allows to set the properties to the package and its items.

4) Connection mangers: Contains the connection managers used in that package.
 
     ** can be package level(used only inside package) or project level(multiple packages)

  i.e during development apps in wizard every time we established a connection to destination but         here once developed can used any no of times

Working with package designing:

We use 2 tabs for this

1)Control flow: Normally logic is implemented using tasks and multiple tasks are placed in one container. This control flow defines flow execution between tasks( sequential or parallel)

2) Data flow: defines flow data from source  to destination

Note: to define data flow we need to use " Data flow task" in control flow tab,






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