DSXchange

Hi

Is there a way/ stage to directly write target data to SQL server from DataStage 7.5.1 . My source is a flat file and with some basic business transformations can i load the data directly to SQL Server inspite of writing to a flat file and loading it.

All your help would be appreciated.

You can use an ODBC Enterprise Stage or a DRS stage , depending on your requiremnnt. Enterprise stage is the option.

Welcome aboard. :D

Since you are running on a Windows platform you also have available the SQL Server Enterprise stage.

However it is not possible to run parallel jobs on Windows version 7.5.1. You can design them, but you can't run them. You need version 7.5x2 to be able to run them in the parallel framework.