
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Run SSIS package via Talend
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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-...

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
