Run SSIS package via Talend

[Anonymous]

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

[Anonymous]

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

[vapukov]

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

[Anonymous]

I have run ssis through talend. If you are familiar with Dtexec utility to run ssis

if your ssis is on remote server,  have PSexec utility installed on your remote server:

https://technet.microsoft.com/en-us/sysinternals/bb897553.aspx

Now what you need to do is write a cmd file and run the command file

command file text could be :

C:\Windows\system32>"\\YourServer\Program Files (x86)\Microsoft SQL Server\110\DTS\Binn\DTExec.exe " /file \\YourServer\SSISDataTools\Package.dtsx

then your TSystem could have C:\Windows\system32>psexec \\YourServe cmd /c J:\NewText.cmd

 you might need to try a few times based on your environment. Hope it helps.

[peacekas99]

Hi,

So if I have a job in SSIS, how do I go about converting this job to a Talend job? I know its mentioned to use Dtexec, is there specific documentation or video on how to go about this process?

Thanks