SSISto transfer from SQl Table into Multiple Excel Sheets

Posted on 2012-09-11
Last Modified: 2012-09-12
I have a table with some data in Management Studio.  I am trying to understand how I can transfer data from one table in Management Studio into multiple excel sheets(not multiple excel files). Could you please guide me through this process. The data resides in 3 different categories in the table. Total, Old and New. I would like to have the 'total' transferred into sheet1, 'old' into sheet 2 and 'new' in sheet 3. These catogories are differentiated by filters in my sql command.

Thnaks in advance
Question by:Josh2442
    LVL 16

    Accepted Solution

    Keith writes it better than I can, and anyhow, it would be far too long an anwer for here!



    Author Closing Comment

    Thanks for this great article
    LVL 16

    Expert Comment

    Thats what I thought when I found it, Josh. The real problems come when you try to have fancy headers and lots of data on the same worksheet!

    Author Comment

    I will keep that in mind. Thanks again

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
    Viewers will learn how the fundamental information of how to create a table.

    758 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

    11 Experts available now in Live!

    Get 1:1 Help Now