Skip to main content
Announcements
A fresh, new look for the Data Integration & Quality forums and navigation! Read more about what's changed.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Labels (3)
4 Replies
Anonymous
Not applicable
Author

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
Master II

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
Not applicable
Author

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
Contributor III

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