SSIS or Windows workflow foundation ?

Question

SSIS or Windows workflow foundation ?

learningsqlkid

SSC Veteran

Points: 280
More actions
August 24, 2016 at 7:34 am

#320908

Hi Guys
I need a help here to understand a real difference between windows workflow and ssis
I am not a c# / vb.net developer
There is a requirement in the project to make we service calls. There are 50 different web services. One of the guy suggested that we should be using windows workflow foundation rather than ssis .. my question is
should we ?
wwf --- flexible enough?
if wwf is the answer then what is the future of ssis ?
please help
Thank you so much

Viewing 5 posts - 1 through 4 (of 4 total)

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

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 1

What exactly are you trying to do? Remember, we can't read your mind. We can only provide answers based on what you tell us.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Phil Parkin SSC Guru Points: 246965 More actions · Answer 2

What do these workflows do?

If you are interacting with data sources and destinations, particularly SQL Server, SSIS offers built-in features which should help speed up development.

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

learningsqlkid SSC Veteran Points: 280 More actions · Answer 3

Hi

Sorry... I guess I was not very clear with the question

Requirement

There are around 50 web services which process the different types user request

I need to call them

I used to call web services through script component in ssis, capture the response , interpret the response by extracting the values from response variable and finally process them

Please note that when i use script component i have to include the web service reference in it, which means that it get the metadata information and other web service related information in the script component and hence I get exposed to functions/methods of the service in script component. (This means for each web service i have to create a new script task)

Now someone in my team mentioned that this can be achieved easily with windows workflow foundation which provides the same capability in much more flexible way

Question: can we use windows workflow for these purpose (orchestration ) or SSIS is still the best choice for me ?

I hope i have made it clear . Please let me know if I am still not clear

Thanks in advance

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 4

learningsqlkid (8/24/2016)
Now someone in my team mentioned that this can be achieved easily with windows workflow foundation which provides the same capability in much more flexible way

That "someone" made the claim... Tell them to put their money where their mouth is and come up with the documentation and the code themselves. You shouldn't have to be the one to prove their claim. They should be.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)