Solved

databse table transfer to excel file

Posted on 2011-03-17
3
212 Views
Last Modified: 2012-08-14
hi experts

I have 3 databases and each database contains 20 tables .I want to transfer all of them into excel file using SINGLE SSIS Package .
Please provide me the detail steps
0
Comment
Question by:sqlcurious
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 5

Expert Comment

by:jijeesh
ID: 35160092
0
 

Author Comment

by:sqlcurious
ID: 35160138
the link shows transferring onlly one table as select dbo.employee

but i have 20 tables how to do that .I think it is not possible to write 20 sql statements
0
 
LVL 3

Accepted Solution

by:
kumarnimavat earned 500 total points
ID: 35165141
You may use the link given below :-

http://www.mssqltips.com/tip.asp?tip=1202
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question