Solved

transfering tables to excel using SSIS

Posted on 2011-03-18
2
365 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:
agarwalrahul earned 500 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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

747 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now