topic Re: Run SSIS package via Talend in Talend Studio

Run SSIS package via Talend

Anonymous — Thu, 20 Oct 2016 07:53:19 GMT

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

Re: Run SSIS package via Talend

Anonymous — Fri, 21 Oct 2016 08:39:45 GMT

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

Re: Run SSIS package via Talend

vapukov — Fri, 21 Oct 2016 13:53:06 GMT

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

Re: Run SSIS package via Talend

Anonymous — Thu, 23 May 2019 19:52:12 GMT

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.

Re: Run SSIS package via Talend

peacekas99 — Mon, 13 Jul 2020 05:17:50 GMT

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