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.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Import/Export is not using Import & Export Wizard

Author  Topic 

yagorik
Starting Member

12 Posts

Posted - 2011-05-27 : 12:03:51
how to Import / Export data from one database to another without using the SQL Server Import and Export Wizard?

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2011-05-27 : 12:13:49
ssis, linked server, bcp out and in, application, another tool

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

yagorik
Starting Member

12 Posts

Posted - 2011-05-27 : 12:21:07
I am new to SQL, you can sample
Go to Top of Page

latch
Yak Posting Veteran

62 Posts

Posted - 2011-05-31 : 11:00:51
Here is a example of how to load data from one table to another table using SSIS:

http://www.petri.co.il/ssis-creating-data-load-package.htm#

Another example of loading data using Excel Source:

http://www.techrepublic.com/blog/datacenter/how-to-import-an-excel-file-into-sql-server-2005-using-integration-services/205

For ssis tutorials: See these:
http://www.accelebrate.com/sql_training/ssis_tutorial.htm
Go to Top of Page
   

- Advertisement -