DSXchange

Hi All,

How to call SSIS package from DataStage ?


Thanks
Chilli

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

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.

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

That would have been my next question.

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....

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

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.

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.

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.