Are you looking for solution to extract Oracle Blob Images to Physical files on Disk using SSIS ?
If yes, then here is the solution.
You can use OLEDB connector to connect to Oracle system , but to gain performance Attunity has came up with connector plugin which is freely distributed on microsoft site ( no license required).
3 steps in data flow are :
1) use Attunity Oracle Connector as source connecting to Oracle DB . It can be downloaded from below link :
2) Derived column which maps base file path ( ex c:\) + File name of file ( we can pull from table or generate new id ) + file mime type ( we can pull from source table ex: jpg, png etc.)
3) Destination Export column.
Link to Download Attunity Connector
Hope it helps...
If yes, then here is the solution.
You can use OLEDB connector to connect to Oracle system , but to gain performance Attunity has came up with connector plugin which is freely distributed on microsoft site ( no license required).
3 steps in data flow are :
1) use Attunity Oracle Connector as source connecting to Oracle DB . It can be downloaded from below link :
2) Derived column which maps base file path ( ex c:\) + File name of file ( we can pull from table or generate new id ) + file mime type ( we can pull from source table ex: jpg, png etc.)
3) Destination Export column.
Link to Download Attunity Connector
Hope it helps...
