MSSQLTips

MSSQLTips.com - your daily source for SQL Server tips

Welcome to MSSQLTips Sign in | Join | Help

MSSQLTips » SQL Server » SQL Server 2005 » Logic to export multiple talbes to individaual files

Logic to export multiple talbes to individaual files

Last post 10-03-2008 2:04 AM by dannyg. 2 replies.

Page 1 of 1 (3 items)
	Sort Posts: Previous Next

09-30-2008 5:38 AM

dannyg
Joined on 09-30-2008
Posts 2

Logic to export multiple talbes to individaual files

Reply Contact

Need logic to implement, export of data from different tables to their respective files in a single batch.. No joins, merge, nothing... just a file containing 'increment' extract of the table. a daily batch.

Filed under: Migrate 2000 to 2005, SQL Server 2005, ssis, SQL Server Instance Names, bcp

10-02-2008 6:31 PM In reply to

timmer26
Joined on 12-14-2007
Kalamazoo, MI, USA
Posts 32

Re: Logic to export multiple talbes to individaual files

Reply Contact

Have you looked into using DTS or SSIS to accomplish this task?

Tim Ford, MCSD

10-03-2008 2:04 AM In reply to

dannyg
Joined on 09-30-2008
Posts 2

Re: Logic to export multiple talbes to individaual files

Reply Contact

I want it in SSIS. This I have done for exporting single table a time. but for this scene( multiple tables to multiple time). I have tried 'foreach loop task'. But cannot get the o/p. I am trying in BCP

Page 1 of 1 (3 items)