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 |
|
tams115
Starting Member
7 Posts |
 Posted - 2006-02-22 : 04:14:43
|
| Hi everyone.i am emporting data from flat to oracle. it works fine. but if a change occure in source (flat file). it does not update that change.i set the time when it should be updated but it doesnt work. how i can resolve my problem. what i do all the steps1st window appear when i clik import export wizard.1: data transformation services...........clik next2: chose a data source n i choose flat or text file and import from the particular location.3:select a file format . i select delimited4: specify column delimited i clik on tab coz my column delimited is tab.5: choose a destination then i select oracle and give the user name n etc.6: i select the destination column from oracle that i have created in oracle n that is availabe under destination column then i click the transform tab n make some changes if required.7:the next window appear save shedule and replicate package.i chek the boxes rum immediately, DTS for later execution n save dts package. At dts later execution i select....occurs:-daily, occurs:-every n give starting n ending time, give starting date n no ending date. 8: next window i give the name of package n other info..server name that is my pc name.9: it copies this data into mentiond table but when i make changing in my flat file (insert new record in it) but it doesnt update those records. i mentioned time when it will update but after that time i checked but it did not update the record or insert.So tell me how i can resolve this problem |
|
|
shallu1_gupta
Constraint Violating Yak Guru
394 Posts |
Posted - 2006-02-22 : 06:02:06
|
Hi,quote:
9: it copies this data into mentiond table but when i make changing in my flat file (insert new record in it) but it doesnt update those records. i mentioned time when it will update but after that time i checked but it did not update the record or insert.
First of all through DTS you cannot update already existing records. However, You can append new records. Did you get any error when you inserted new records into your flat file and executed your the package again? |
 |
|
|
tams115
Starting Member
7 Posts |
Posted - 2006-02-22 : 07:42:09
|
| Hi,i do not want to update this data. i want to load new data. when i load it again whole data it doesnt give any at creating table n copying data. but at the a window appear having msg "The instruction at "0x7c910f29" referenced memory at "0xfffff". The memory could not be "read" at the end of dts process.first i want to load new data that is new in text file or my source.2: and u said i cant update data through dts so which tool is user for updation or it is handeld by oracle. So tell me what should to tdo? |
|
|
|
|
|
|
DTS data updation problem