Loading to SQL Server

bensonian · Post by **bensonian** » Fri Sep 01, 2006 11:37 am

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.

thumsup9 · Post by **thumsup9** » Fri Sep 01, 2006 12:22 pm

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

ray.wurlod · Post by **ray.wurlod** » Fri Sep 01, 2006 9:16 pm

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.