Solved

transfering tables to excel using SSIS

Posted on 2011-03-18
2
376 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …

615 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