Results 1 to 2 of 2

Thread: import data into sql table from another table using ssis packages

  1. #1
    Join Date
    Oct 2010
    Posts
    24

    import data into sql table from another table using ssis packages

    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 time

    the whole amount data is transferred.. and now i want to transfer only the daily updates

    i.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..

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    You can filter data by timestamp or so provided that table has such column.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •