Export-Import multiple tables between servers using SSIS

• tirumalasetty116 72483

  SSC Enthusiast

  Points: 157

  More actions

  November 11, 2011 at 3:23 pm

  #251713

  Hello,

  I have a requirement to export multiple tables (about 51 in count) from mysql and import into sql server 2005 using SSIS with same table name and column names. I have to create a job to run every 10 minutes to import new data from the last run. Can anyone suggest me a way to do it?

  Thanks,

  Pavan

• Koen Verbeeck

  SSC Guru

  Points: 259155

  More actions

  November 14, 2011 at 12:37 am

  #1406934

  The initial load you can probably do with the Import/Export wizard in SSMS.

  It gives you the ability to quickly generate an SSIS package that will load the 51 tables as-is.

  Regarding the 10 minute job:

  you'll need to modify to SSIS package generated by the Import/Export wizard so that it can handle delta loads (or incremental loads).

  Starting point for incremental load:

  http://sqlblog.com/blogs/andy_leonard/archive/2007/07/09/ssis-design-pattern-incremental-loads.aspx

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