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 60: Create folders and Data sources by Report Manager in SSRS

How to create folders and Data sources by using Report Manager in SSRS Firstly select the report manager URL from reporting services configuration and go to the reporting services home. Next click on New Folder option and create a folder for data sources, also create various folder for Data Sets and Reports. Now click on the Details view in order to move or delete multiple reports at once. For creating a New Data Source click on the New Data source in the Home and provide the connection string, also connect using a service account so that we can provide access to that service account and every one uses that service account for connecting to the database. Finally after adding/deploying a report, select manage from the dropdown and choose the correct datasource .
Post a Comment
Read more