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
sqlcuriousAsked:
Who is Participating?
 
kumarnimavatCommented:
You may use the link given below :-

http://www.mssqltips.com/tip.asp?tip=1202
0
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.