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.
Loading attachments via DataStage to SQL Server
Moderators: chulett, rschirm, roy
Loading attachments via DataStage to SQL Server
Regards,
Ganesh
Ganesh
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
-
- Premium Member
- Posts: 1044
- Joined: Wed Sep 29, 2004 3:30 am
- Location: Nottingham, UK
- Contact:
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.ray.wurlod wrote:You will need to use Microsoft facilities. There is no mechanism in DataStage for this task. ...
Maybe the DS server script could telnet onto the Windows box and run BCP that way...
Phil Hibbs | Capgemini
Technical Consultant
Technical Consultant