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 |
|
tpavan7329
Starting Member
18 Posts |
 Posted - 2011-11-11 : 17:12:23
|
| 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 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-12 : 05:52:20
|
| the easiest way to do this is using ssis export import wizard and then saving it as a package and scheduling it as a sql agent job to execute every 10 minutes------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Export Import Multiple Tables between servers