Hi all,
I would like to know if any of you has experienced with interaction between DataStage and DTS??
In this case we would like to invoke packages in DTS from DataStage jobs or sequences.
Thanks in advance
Julio
DTS and DataStage connectivity
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
If you can execute DTS packages from the command line through some type of db connection command then you can run a script from a DataStage routine via the DSExecute command. If you can run packages from a SQL Server stored procedure you could try using the ODBC stage to execute the procedure from within a dummy job (processes one dummy row to trigger the stored procedure).
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn