Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to "read" a blob for use in DTS

Status
Not open for further replies.
williamwhite

williamwhite

Programmer
Nov 3, 2003
13
NL
Hello,

We use an oracle datebase. There are tables were the data is saved as BLOB. The data in the BLOB is only text. How can i convert this blob to a data string so i can use it for the import in MS SQL
 
Status
Not open for further replies.

Similar threads

tekpr00
  • Locked
  • Question
Help with concatenation of BIG integers
Replies
0
Views
162
tekpr00
tekpr00
jeffwest21
  • Locked
  • Question
BCP Out file with double quotes
Replies
1
Views
254
gk53
gk53
ItHurtsWhenIThink
  • Locked
  • Question
Using Distinct and count in same query???
Replies
4
Views
198
gk53
gk53
Rene1024
  • Locked
  • Question
Help with a Bulk insert statement
Replies
1
Views
201
drlex
drlex
betachristopher
  • Locked
  • Question
Use IF/ELSE in Query 1
Replies
3
Views
179
drlex
drlex

Part and Inventory Search

Sponsor

Back
Top