• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 399
  • Last Modified:

transfering tables to excel using SSIS

hi  experts
i am creating ssis package that transfers tables to excel sheet from multiple daatabses using SINGLE SSIS Package.I came to solution(whether correct or not) like below,But i dont know the proper steps

How to use SSIS and   make
loop over each database to get the table name into a variable, use the variable as source to get the data from and then export it into the excel file.

Pleae provide me the detail steps if possible
0
sqlcurious
Asked:
sqlcurious
1 Solution
 
sqlcuriousAuthor Commented:
hi rahul:

the link u gave to me shows only one table.Is there any way to transfer multiple tables from one db to one excel file but different excel sheet.Actually i have 3 databases and needs to transfer to three excel files using single package
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

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