Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ducepair
Starting Member
7 Posts |
 Posted - 2009-07-25 : 01:44:15
|
| Hi all, i have gone through some useful topics on SSIS before in SQL team and i thought i will get good respose if i post my issue here. I have a business scenario where i have to create a DTS package to pul the data from DB2 data base which has CLOB field in it and my target is Oracle DB. I tried using Db-link but i was not able to select the CLOB field though db-link. Then i created a DTS package(we still using SQL Server 2000) and it doesn't allow me to select CLOB field from target data base. Finally i ended up creating a LONG and i try to execute it. It started well and it loaded 1630 records and gave an exception [IBM][CLI Driver][DB2/NT] SQL0973N Not enough storage is available in the "APP_CTL_HEAP_SZ" heap to process the statement. SQLSTATE=57011 I check with my DBA team and they suggested me to run by month wise. Now i want few suggession from anyone, how to do this scenario. I have to pull 6 months of data and i can do this by executing the DTS package by running it 3 time with different dataes in the Query because of the CLOB field.But when i move it to production DBA doesn't execute it 3 times. And i first run it it has to load all 6 months data and from next day onwards i want to load one day data.I want to do this either creating 3d ifferent batch files with different date parameters.can anyone suggest me how to do that. Or Can anyone suggest me with best solution for this.?Suggession are greatly appreciated.Thank you all very much |
|
|
|
|
|
DTS package to load DB2 CLOB field in Oralce