DTS and DataStage connectivity

jusami25 · Post by **jusami25** » Tue Jan 24, 2006 3:54 am

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

vmcburney · Post by **vmcburney** » Tue Jan 24, 2006 4:09 am

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