Page 1 of 1
Loading attachments via DataStage to SQL Server
Posted: Thu Mar 31, 2011 9:43 am
by dganeshm
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.
Posted: Thu Mar 31, 2011 3:35 pm
by ray.wurlod
You will need to use Microsoft facilities. There is no mechanism in DataStage for this task.
Posted: Fri Apr 01, 2011 1:08 am
by Sreenivasulu
You can read excel (with some limitations like - no macros ) using a java api . Register the .so in the unx box.
Regards
Sreeni
Posted: Fri Apr 01, 2011 2:56 pm
by dganeshm
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
Posted: Tue Apr 05, 2011 9:11 am
by PhilHibbs
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...