Process of SSIS

Question

Post reply

Process of SSIS

Raj9

Old Hand

Points: 333
More actions
December 15, 2010 at 5:23 am

#144024

Can anyone explain the process of ssis.What is the job process

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246960 More actions · Answer 1

Please be more specific. At the moment, my answer would be

1) Job starts

2) Job executes

3) Job completes

which I doubt is the answer you require.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Raj9 Old Hand Points: 333 More actions · Answer 2

thank u very much for your reply.Ya i know job starts ,executes and compltes but what will be the output for the endusers.I will tell the process so clarify is it correct.

First we get the source data using raw package then we do transformations and loading the data to the fact tables and dimension tables.Then we process the cube. then the end users will view the reports through cube.So is it correct.

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 3

Well, this depends on how you run it. If they manually trigger the job, they get a little box on the screen showing it's running, then either error or complete. If it's via a job, noone sees anything, that's the point. If you open it in BIDS or VS, you can see the package run.

There's no 'user interface' or output. It's a package, it's meant to be run with no interaction, under 95% of circumstances. If you need your users to see something, you'd have to build it in.

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA

Raj9 Old Hand Points: 333 More actions · Answer 4

Hi craig i just want to know, in the interveiw what we have to explain about the SSIS job

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 5

Oh allright, it is for an interview. Why didn't you mention this in the beginning?

Your answer should definately be:

first yellow boxes. If you're lucky, green boxes. If not, red boxes. If you're in trouble because SSIS is waiting on something, the yellow boxes stay yellow. That should summarize it.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Raunak Jhawar SSCoach Points: 15701 More actions · Answer 6

da-zero (12/16/2010)
Oh allright, it is for an interview. Why didn't you mention this in the beginning?
Your answer should definately be:
first yellow boxes. If you're lucky, green boxes. If not, red boxes. If you're in trouble because SSIS is waiting on something, the yellow boxes stay yellow. That should summarize it.

I just love this place...super good

@Vikram...study brother...study hard

Raunak J

Phil Parkin SSC Guru Points: 246960 More actions · Answer 7

da-zero (12/16/2010)
Oh allright, it is for an interview. Why didn't you mention this in the beginning?
Your answer should definately be:
first yellow boxes. If you're lucky, green boxes. If not, red boxes. If you're in trouble because SSIS is waiting on something, the yellow boxes stay yellow. That should summarize it.

😀 slightly more useful than my answer. I was wondering what those red boxes meant.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 8

vikram2010 (12/16/2010)
Hi craig i just want to know, in the interveiw what we have to explain about the SSIS job

The correct answer, then, is: "I don't know, I haven't used SSIS before."

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 9

Craig Farrell (12/16/2010)
vikram2010 (12/16/2010)
Hi craig i just want to know, in the interveiw what we have to explain about the SSIS job
The correct answer, then, is: "I don't know, I haven't used SSIS before."

Or:

SSIS is a great product, but it could use a little more cowbell.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP