Run SSIS package via Talend

Five Stars

Run SSIS package via Talend

Hi Guys,
I have a question. Our task needs to run SSIS package natively in Talend. We were wondering if this is possible? 
I've heard that it is not possible because SSIS packages could not be deployed on the Java Virtual Machine. But we are also wondering about the other possibilities like maybe using Stored procedures to deploy the SSIS packages and then running those stored procedures via Talend? or the possibility of running the SSIS package via commandline and then incorporate it in Talend thru the 'tSystem' component? 
Any thoughts would be gladly appreciated,
Thanks,
Locke
Moderator

Re: Run SSIS package via Talend

Hi,
Could you please take a look at this new feature jira issue:https://jira.talendforge.org/browse/TUP-4779 to see if it is what you are looking for?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Thirteen Stars

Re: Run SSIS package via Talend

Hi,
Could you please take a look at this new feature jira issue:https://jira.talendforge.org/browse/TUP-4779 to see if it is what you are looking for?
Best regards
Sabrina

It is different
You can use both method:
- run stored procedure
- run tSystem
both working, for example - http://www.databasejournal.com/features/mssql/executing-a-ssis-package-from-stored-procedure-in-sql-...
-----------