Hello noggin,

i tried by putting the file in different location.

Now i get some other error.

Please help me if i need to change some setting in the Schedule Job.

...   DTSRun:  Executing...  ...

Hello frnds,

I get the following error after considering the Dinesh's idea.

DTSRun:  Loading...   DTSRun:  Executing...   DTSRun OnStart:  DTSStep_DTSExecuteSQLTask_4   DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_4   DTSRun OnStart:  DTSStep_DTSDataPumpTask_1   DTSRun OnError:  DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005)     ...

Hi Dinesh i tried this.Still it gives the error.

I think it has something to do with the opening of csv file.

Any security setting that i need to setup??

Please help.

Thanks in...

u can try to disable the constraints manually in the destination and carryout the DTS..that wud be simpler

thnks

hi dinesh..

jus use save as option and save it in structured storage file format ..that can be portable

thnks

hi dinesh..

jus use save as option and save it in structured storage file format ..that can be portable

thnks

hi paul

jus try to clear the events in application log...

go to event viewer---action--clear events--dont save it wen u get a pop up for save..

make sure u  hav the rights to...

hi i am jus trying out..

we can pull all the datda from Oracle to SQL server and run a store procedure to compare and update accordingly...

i am also trying for...