Call SSIS package from DataStage 9.1

chillisrp · Post by **chillisrp** » Thu Apr 30, 2015 8:21 am

Hi All,

How to call SSIS package from DataStage ?

Thanks
Chilli

chulett · Post by **chulett** » Thu Apr 30, 2015 9:12 am

How would you call it if you weren't using DataStage?

SURA · Post by **SURA** » Thu Apr 30, 2015 5:57 pm

SSIS package cab be trigger from the command line. Use the command activity stage to trigger it from DataStage.

I haven't tried, but in theory it should work.

ray.wurlod · Post by **ray.wurlod** » Thu Apr 30, 2015 9:35 pm

Why do you want to invoke what amounts to one ETL tool from another?!!

chulett · Post by **chulett** » Thu Apr 30, 2015 11:29 pm

That would have been my next question.

taylor.hermann · Post by **taylor.hermann** » Fri May 01, 2015 10:32 am

We have a requirement to do this as well...
And it has been a nightmare trying to piece together the best way to do it....
Someone mentioned doing this within a stored procedure but didn't really explain why or how to....

chillisrp · Post by **chillisrp** » Tue May 05, 2015 7:31 am

Thank You All.

I am planing to execute the SSIS package from Execute Command stage and see ...

This is a kind of unique requirement

Please let me know any solutions ....

Thanks
Chilli

ray.wurlod · Post by **ray.wurlod** » Tue May 05, 2015 4:38 pm

My (implied) solution is "don't do it".

<rant>
Resist stupid requirements!
</rant>

Otherwise track down a command line mechanism for invoking your package and use that, perhaps from an External Source stage if stdout will receive the required output from the package.

Tina_HANHAN · Post by **Tina_HANHAN** » Thu May 07, 2015 3:44 am

Do you want to call SSAS package(SSIA package call SSAS package.for example:refresh SSAS cube) ?
I have the same problem, anyone who experienced people to solved help us.
How to call SSAS package from DataStage ?
ps: SSAS or SSIS's OS is windows.

chulett · Post by **chulett** » Thu May 07, 2015 7:04 am

You have 'the same problem' and I have the same question - how would you call it if you were not using DataStage? The answer to that question will lead to the solution.

Or you can always involve the experienced people at your official support provider.

DSXchange

Call SSIS package from DataStage 9.1

Call SSIS package from DataStage 9.1

Re: Call SSIS package from DataStage 9.1

Re: Call SSIS package from DataStage 9.1