Bulk Insert into text field in SQL 2008 Management express

• spathak32

  SSC Enthusiast

  Points: 184

  More actions

  March 15, 2010 at 7:58 am

  #219870

  Hi,

  I have a table called TESTOUPUT in Oracle 10g and it contains 3 columns

  ID_ VARCHAR2(7),

  TEXT CLOB,

  PROCESSED NUMBER

  and same table I have created in SQL 2008 Express.

  now I want to copy the data in CLOB of Oracle to TEXT field

  How should I do this.

  Format of my CLOB is as below: -

  =============================================================

  {1:F01SGL1XXXXXXXX0000000000}{2:I541ABCIBHBMXXXXN}{3:{108:1212}}{4:

  :16R:GENL

  :20C::SEME//RS5100801

  :23G:NEWM

  :98C::PREP//20100223094459

  :16S:GENL

  :16R:TRADDET

  :98A::SETT//20100227

  :98C::TRAD//20100219090000

  :90B::DEAL//ACTU/EUR10,

  :35B:ISIN ES0113900J37

  BANCO SANTANDER

  :16S:TRADDET

  :16R:FIAC

  :36B::SETT//UNIT/5000,

  :97A::SAFE//REC050

  :16S:FIAC

  :16R:SETDET

  :22F::SETR//TRAD

  :22F::STCO//PART

  :16R:SETPRTY

  :95P::SELL//AAALSARI

  :97A::SAFE//76767676

  ======================================================

  Please help me as SQL 2008 doesn't support the Query Analyzer capabilities.

  Thanks,

  Sandeep