Dear all, i'm very new with SSIS, do you have an example to refresh data from one database to another database i just want to refresh data, can'tuse backup/restore . ie. DATABASEONE tab1, tab2 refresh data to DATABASETWO tab1,tab. many thank's
HI,This you can do as we used it in DTS. You can used the import/export option right clicking the database and the Wizard will take you how to do it. Refer this link: http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/32f0da8f-035d-4a0e-9b95-a05f6a5ca2de this will give you more info.Regards-Johnson
You don't have to use SSIS. You can use the Copy Database Wizard, The Copy Database Wizard lets you move or copy databases and their objects easily from one server to another, with no server downtime. Using this wizard, you can do the following: Pick a source and destination server. Select databases to move or copy. Specify the file location for the databases. Create logins on the destination server. Copy additional supporting objects, jobs, user-defined stored procedures, and error messages. Schedule when to move or copy the databases.
yes but, i have to control commit size option with big tables, and i don't want to drop the table before, cause somes columns have changed (ie char(50) instead of char(10) ) ...