transfere data only from database to another

• ahmed_elbarbary.2010

  Hall of Fame

  Points: 3118

  More actions

  March 31, 2012 at 12:47 pm

  #254060

  hi guys i need to create ssis package to take all data(data only) from one database to another

  and if i want to take last updated data only by ssis package are this possible

  these databases in more serveres

  the two databases have same structure and tables every thing is same but different only data

  my software database is sql server 2005

  how can i make this

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  March 31, 2012 at 1:24 pm

  #1467328

  Duplicate request - please post answers here.

  http://www.sqlservercentral.com/Forums/Topic1276204-391-1.aspx

  Jason...AKA CirqueDeSQLeil
  _______________________________________________
  I have given a name to my pain...MCM SQL Server, MVP
  SQL RNNR
  Posting Performance Based Questions - Gail Shaw[/url]
  Learn Extended Events