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

x
?
Solved

transfering tables to excel using SSIS

Posted on 2011-03-18
2
Medium Priority
?
381 Views
Last Modified: 2012-05-11
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
Comment
Question by:sqlcurious
2 Comments
 
LVL 13

Accepted Solution

by:
Rahul Agarwal earned 2000 total points
ID: 35170031
0
 

Author Comment

by:sqlcurious
ID: 35172531
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

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…

972 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