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!

is this possible? - unblob column

Status
Not open for further replies.
Bell1991

Bell1991

Programmer
Aug 20, 2003
386
US
I have a table that contains xml documents blobbed up and stored as a text column. I would like to unblob them and either store them into a file and re-import them in or when the column is readable read it into another table for analysis.

Is this possible without writing a windows app? Can it be done in SSIS?

I looked at the export column, but i am not sure if that will work.. Based on what it says for the "File Path Column" i don't have that information in the table.
 
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
CSV to SQL table with not allow null issue
Replies
3
Views
235
Cpreston
Cpreston
sugu.bala
  • Locked
  • Question
Dynamic Input column in Script task
Replies
0
Views
151
sugu.bala
sugu.bala
appelq
  • Locked
  • Question
SSIS import from CSV is truncating the Decimal 1
Replies
2
Views
272
appelq
appelq
Enlightme
  • Locked
  • Question
SSIS adding new columns to existing table
Replies
0
Views
79
Enlightme
Enlightme
Cpreston
  • Locked
  • Question
Truncate if possible 1
Replies
3
Views
83
micang
micang

Part and Inventory Search

Sponsor

Back
Top