Loading attachments via DataStage to SQL Server

dganeshm · Post by **dganeshm** » Thu Mar 31, 2011 9:43 am

Hi,

I have a requirement to load attachments like MS Word , Excels or emails to SQL Server. Anybody have any advice on how to do it.

ray.wurlod · Post by **ray.wurlod** » Thu Mar 31, 2011 3:35 pm

You will need to use Microsoft facilities. There is no mechanism in DataStage for this task.

Sreenivasulu · Post by **Sreenivasulu** » Fri Apr 01, 2011 1:08 am

You can read excel (with some limitations like - no macros ) using a java api . Register the .so in the unx box.

Regards
Sreeni

dganeshm · Post by **dganeshm** » Fri Apr 01, 2011 2:56 pm

Sreenivasulu wrote:You can read excel (with some limitations like - no macros ) using a java api . Register the .so in the unx box.

Regards
Sreeni

Hi Sreeni,

Can you point me towards some Java API.

Regards,
Ganesh

PhilHibbs · Post by **PhilHibbs** » Tue Apr 05, 2011 9:11 am

ray.wurlod wrote:You will need to use Microsoft facilities. There is no mechanism in DataStage for this task. ...

The closest you could get is to use DataStage to write out the contents of a script that calls a Microsoft command line utility to load the BLOB record - not sure if BCP would be the tool for that - and run this generated script as an After Job thingy. That would only work on a Microsoft Windows DataStage server though, I don't think there is a port of BCP for Unix.

Maybe the DS server script could telnet onto the Windows box and run BCP that way...