SSIS For Loop Container Task

SSIS For Loop Container Task:

Why For Loop Container Task is Use ?

• Name of the task itself explains most of of it !! For Loop container is falls under container and looping tasks
• Use containers like the For Each Loop and For Loop to execute a set of tasks multiple times.
• For example, you can loop over all the tables in a database, performing a standard set of operations like updating index statistics. 
  In short when we have to iteratively execute set of task we will insert all those task under For Loop Container and set the values accordingly
• For loop task is the looping implementation of a task and also This task will evaluate an expression and loops through the process and until the evaluation goes to False.

The For Loop container uses the following elements to define the loop:

1. An optional initialization expression that assigns values to the loop counters.
2. An evaluation expression that contains the expression used to test whether the loop should stop or continue.
3. An optional iteration expression that increments or decrements the loop counter.
   

ssis,ssrs,ssqs engines

ssis,ssrs,ssqs engines:

Speaking about Microsoft Business Intelligence stack i.e. SSIS / SSAS / SSRS, there are different engines associated with each services. If you are ignorant about these engines, you probably are not fit to design the architecture of your solution using the respective services. The major engines that comes into consideration when you are using MS BI stack are as below:

1) SSIS Runtime Engine - This engine takes care of the administration and execution section of SSIS. In a developer language, I would consider it a Control Flow + SSMS of SSIS.

2) SSIS Data Flow Engine - This engine can be considered as the Buffer Manager of SSIS in-memory architecture.

3) SSAS Formula Engine - The engine takes care of resolving the retrieval of members on any axis of an MDX query. Tuning the performance of this engine has much to do with MDX tuning.

4) SSAS Storage Engine - This engine can be considered as the Data Manager of SSAS, which decides what data needs to be fetched from where. If you trouble Formula Engine, there is a good possibility that this would cascade to Storage Engine, which directly deals with aggregations.

5) SSRS Service Endpoint - This cannot be technically considered as an engine, as most people would argue that rendering / authentication / processing are engines, but I consider these as extensions rather than engines. This endpoint takes care of the administration part of SSRS. Anything that you can do with Reports Manager is a virtue of this endpoint.

6) SSRS Execution Endpoint - This is the endpoint that one would like to award the medal of being an engine. This endpoint takes care of executing the report right from processing the RDL till rendering the report.

You can read more about each of these in MSDN as well as different books and blogs. But until you thoroughly understand the function of these engines and you are designing the architecture, I am of the opinion that one should not feel confident about the architecture design.

SSIS Balanced Data Distributor transform

SSIS Balanced Data Distributor

Transform:

Microsoft download center has a new download available that would be of interest to many SSIS professionals. Its a new transform named Balanced Data Distributor transform, which takes a single input and distributes the incoming rows to one or more outputs uniformly via multithreading. Below mentioned is the description of this transform as mentioned on the download page:

"Microsoft® SSIS Balanced Data Distributor (BDD) is a new SSIS transform. This transform takes a single input and distributes the incoming rows to one or more outputs uniformly via multithreading. The transform takes one pipeline buffer worth of rows at a time and moves it to the next output in a round robin fashion. It’s balanced and synchronous so if one of the downstream transforms or destinations is slower than the others, the rest of the pipeline will stall so this transform works best if all of the outputs have identical transforms and destinations. The intention of BDD is to improve performance via multi-threading. Several characteristics of the scenarios BDD applies to: 1) the destinations would be uniform, or at least be of the same type. 2) the input is faster than the output, for example, reading from flat file to OleDB. "

Considering the test performed on this transform, from the results it seems that performance of this transform is a little better over other transforms like Script and Conditional Split. But it should also be taken into consideration that this transform buffer by buffer to its output ends, and the other two checks the data based on the specified logic and then divides the data. Its a nice transform to have in your existing SSIS toolbelt.

The best use of this transform that I can think of is when your input is extremely fast, and you have replicated blocks of logic to keep up the pace with the incoming data flow. In such a case BDD acts as a distributor bridge pumping data to all logic pipelines. But if data is to be dissected conditionally, Conditional Split would be the option again. The speed of distribution harnessed by this transform seems to be due to two reasons: 1) No distribution of data conditionally, just pass buffer by buffer 2) Multithreading architecture.

Certain curious questions the my mind raises are:

1) Denali is already in CTP mode and more CTPs are expected to come. Then why this transform has been released separately at this time and so silently?

2) Will this transform be a regular transform available with Denali, or would it remain a mysterious separated out transform?

3) This transform is available only for SSIS 2008 and SSIS 2008 R2, not SSIS 2005. Why ? Actually it's SSIS 2005 that needs more help with transforms like this, where it would be a value addition to customers who have already made investments in SSIS 2005 !

Let's look forward to the next CTP of Denali to checkout whether this transform would have a seat in SSIS Denali.

MSBI Developer

Next Step Services Private Limited
(posted 1 day back)


job Description

• Graduate degree or equivalent experience. (B.Tech/MCA preferred)
• Strong experience in MSBI is required.
• Expert in data analysis using Microsoft tools: Access, SSIS, SSRS, MS-SQL Developer.
• Advanced reporting capabilities.
• Advanced data ETL skills.
• Strong facilitation, critical thinking, problem solving, decision making and analytical skills.
• Excellent verbal, written communication and presentation skills

Job Posted by

• Company:Next Step Services Private Limited

Next Step Services Private Limited is a multi-disciplined recruitment consulting firm. We serve a wide range of clients throughout India, from Fortune 500 companies to Small & Medium Enterprises across a variety of industry sectors. It is our mission to provide effective recruitment consulting services which enable our clients to develop and achieve their objectives. We do this by being innovative, professional and proactive in regards to every aspect of our recruitment practice

EXPERIENCE: 3 to 5 yrs

SALARY:As per Industry Standards

LOCATION:Noida / Greater Noida

JOB FUNCTION: IT / Telecom - Software

INDUSTRY:Consulting Services

SPECIALIZATION: Application Programming , Business / Systems Analysis , Database Administration ( DBA ) , Software Engineer

QUALIFICATION: MCA / PGDCA (Computer Science )

BE / B.Tech ( Engineering ) (Computer Science )

How to pass parameter from Report Viewer Control to sub report?

How to pass parameter from Report Viewer 

Control to sub report?

Microsoft ReportViewer is the best alternative to Crystal Reports. In fact it is very easy to create RDLC report compare to crystal reports.

Here are some of the features in this source code:

1. Add subreport in addition to main report. Also called Parent and Child report.
2. Pass parameter from main report to subreport.
3. Use ID or the primary key of the main report to Fill DataSet of Subreport to speed up loading its loading time.
4. Load report programmatically.

Senior Software Engineer - MSBI

Senior Software Engineer - MSBI

(posted about 5 days back)

Designation	Senior Software Engineer - MSBI
Job Description	It takes courage to find out how good you can be. At Optum, we're using leading-edge technology to create the health care system of tomorrow.  When you join us as a . Net Applications Developer, you'll become part of a team focused on innovation and change. You'll work a little harder. You'll aim a little higher.  You'll expect more from yourself and others. And at the end of the day, you'll be doing a lot of good. Through a lot of inspired individuals, we are using technology to build a health care system that works better for more people in more ways than ever.  We are looking to reinforce our team with people who are decisive, brilliant and built for speed -- people like you. As a Developer, you will be predominantly involved in developing business solutions by creating new and modifying existing software applications.  You will be a primary contributor in designing, coding, testing, debugging, documenting and supporting all types of applications consistent with established specifications and business requirements to deliver business value.  This is more than a challenging development role. This is high performance technology. Are you up for the challege Join us and start doing your life's best work.  (SM)Primary Responsibilities: Design, implement and maintain within all phases of the Software Development Life Cycle (SDLC) Develop, test, implement and maintain application software working with established processes Communicate effectively with other engineers and QA Establish, refine and integrate development and test environment tools and software as needed Identify production and non-production application issuesIdentify opportunities to fine-tune and optimize
Desired Profile	Preferred Qualifications:- Educational Qualifications: B. Tech / MCA / Msc / MTech (Minimum 16 years of formal education, Correspondence courses are not relevant).  - experienced developers  Should have good experience in SQLServer.  - Should have written stored procedures and functions.  - Should be strong in SQL- Should be familiar with ETL concepts - Should have good experience in SSIS and data loading using SSIS - Exprience of developing ETL processes and troubleshooting jobs using SSIS.  - Experience in optimizing and improving ETL processes. - Should have very strong communication skills and ability to communicate with business directly.  Nice to Have: Experience in US Healthcare industry. Technology Careers with Optum. Information and technology have amazing power to transform the health care industry and improve people's lives. This is where it's happening.  This is where you'll help solve the problems that have never been solved. We're freeing information so it can be used safely and securely wherever it's needed. We're creating the very best ideas that can most easily be put into action to help our clients improve the quality of care and lower costs for millions. This is where the best and the brightest work together to make positive change a reality.   This is the place to do your life's best work. SMDiversity creates a healthier atmosphere: UnitedHealth Group is an Equal Employment Opportunity/ Affirmative Action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law.  UnitedHealth Group is a drug-free workplace. Candidates are required to pass a drug test before beginning employment.  Requirements- Associate's Degree or higher level of education or equivalent experience - 2+ years experience with relational database management systems (e. g. . Access, SQL or Oracle, FileMaker Pro 9)- 2+ years experience performing data analytics and reporting- 2+ years Advanced level of proficiency with MS Excel- Strong problem solving and analytical skills Assets - Experience with object-oriented programming systems- Proficiency with MySQL/ PHP- Knowledge of data release precautions and HIPAA regulations Combine two of the fastest-growing fields on the planet with a culture of performance, collaboration and opportunity and this is what you get. Leading edge technology in an industry that's improving the lives of millions. Here, innovation isn't about another gadget, it's about making health care data available wherever and whenever people need it, safely and reliably. There's no room for error.  Join us and start doing your life's best work. (sm)Technology Careers with Optum. Information and technology have amazing power to transform the health care industry and improve people's lives. This is where it's happening. This is where you'll help solve the problems that have never been solved. We're freeing information so it can be used safely and securely wherever it's needed.  We're creating the very best ideas that can most easily be put into action to help our clients improve the quality of care and lower costs for millions. This is where the best and the brightest work together to make positive change a reality. This is the place to do your life's best work.  SMDiversity creates a healthier atmosphere:  UnitedHealth Group is an Equal Employment Opportunity/ Affirmative Action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law. UnitedHealth Group is a drug-free workplace. Candidates are required to pass a drug test before beginning employment.
Experience	5 - 8 Years
Industry Type	Pharma / Biotech / Clinical Research
Role	Software Developer
Functional Area	IT Software - Application Programming, Maintenance
Education	UG - B.Tech/B.E. - Any Specialization PG - M.Sc - Any Specialization, MCA - Computers, M.Tech - Any Specialization Doctorate - Any Doctorate - Any Specialization, Doctorate Not Required
Compensation:	Not disclosed
Location	Hyderabad / Secunderabad
Keywords	Senior Software Engineer - MSBI Net Applications Developer designing coding testing debuggingdocumenting Software Development Life Cycle SQL MySQL PHP
Contact
Job Posted	2016-08-23 11:49:06.0
Reference	672539

Msbi/ Power BI Developer - Ssas/ Ssis/ SQL Server

Msbi/ Power BI Developer - Ssas/ Ssis/ SQL Server

Job Description

Send me Jobs like this

- Power BI Desktop - for Data model preparation and Visuals

- SSAS Tabular Model - Mandatory

- SSIS - would be an added advantage

- Row Level Security Implementation - Mandatory

- SQL Server 2016 - Model Data Refresh/Schedules/Jobs setup etc

- ANSI SQL - Mandatory for data validation

Please reply with billow details :

Location :
CTC :
ECTC :
Notice Period :
Reason for job change :
Skype ID

Desired Candidate Profile

Education-

UG:Any Graduate - Any Specialization

PG:Any Postgraduate - Any Specialization, Post Graduation Not Required

Doctorate:Doctorate Not Required

Company Profile:

Readmind Info Services

Leading client of Readmind Info Services