SSIS Packages Local-Server

• mirzabaig.imran

  SSC Rookie

  Points: 35

  More actions

  November 23, 2011 at 5:55 am

  #246656

  Hi Guys,

  I am new to SSIS i need a help from you guys.

  As i want to insert my local table from SqlServer 2008 express (my system) to SqlServer 2008 R2 (Main Server) and the data to be inserted should be only new data which is modified i.e inserted.

  As i have tried Look Ups control but i am getting some error so, please guide what settings and configuration i have to do.

  As we can use date field to match what data to be inserted at the server. As the date which is not present in the Main Server Table can be inserted.

  Thanks In Advance,

  MIB.

• Koen Verbeeck

  SSC Guru

  Points: 259197

  More actions

  November 25, 2011 at 3:44 am

  #1412929

  It would be useful if you at least provided us the error that you got.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP