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 |
|
vinu
Starting Member
34 Posts |
 Posted - 2010-12-27 : 02:19:32
|
| hi... all.i've created one package using ssis ..That is used for transferring the data from the tableA to tableB daily at evening..now my problem is ..i've huge amount of data i.e upto 2GB of data while transferring for first timethe whole amount data is transferred.. and now i want to transfer only the daily updatesi.e what data i've entered today that much only it should transfer instead of whole data (2GB)..how to do it .. please help me.. |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-27 : 03:46:39
|
| You need somethig on the source table that you can use to identify new data. Could be an identity, timestamp, updatedate.If not then you are stuck with comparing the tables or transactional replication.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
import data into sql table from another table