Hi
The source and desitination tables reside in different databases; Pervasive and SQL respectively. I'm looking to do update and inserts on a scheduled basis using dts.
Is it possible to do both functions in 1 operation? If not then is there any quick way to insert only elements that are new to the destination table, without having to use a temp table? The same question would apply for the update operation as well.
Since these temp tables can become really large really fast, and if I have to load these temp tables every time then it's going to be slow.
Thanks for your help
-d
The source and desitination tables reside in different databases; Pervasive and SQL respectively. I'm looking to do update and inserts on a scheduled basis using dts.
Is it possible to do both functions in 1 operation? If not then is there any quick way to insert only elements that are new to the destination table, without having to use a temp table? The same question would apply for the update operation as well.
Since these temp tables can become really large really fast, and if I have to load these temp tables every time then it's going to be slow.
Thanks for your help
-d