Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 229
  • Last Modified:

databse table transfer to excel file

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
sqlcurious
Asked:
sqlcurious
1 Solution
 
sqlcuriousAuthor Commented:
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
 
kumarnimavatCommented:
You may use the link given below :-

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

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Tackle projects and never again get stuck behind a technical roadblock.
Join Now