Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

extract data from oledb source to excel work sheets Expand / Collapse
Author
Message
Posted Tuesday, September 28, 2010 5:11 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, December 4, 2010 8:57 PM
Points: 1, Visits: 23

hi,

i have 3 tables they are pcategory,psubcategory,product.i get the data from three tables using with joins and given group by columns pcat,psubcat,product.and pcategory has 4 categories like A,B,C,D.and i want the data like category wise i.e all details of category A,B,C,D are will loaded into 4 excel files and and each category has some subcategories and they will loded into sheet wise respective of thier category data.

ex: A contains three sub categories like a,b,c and they will loaded in to sheet1,sheet2,sheet3 respectively

it is the task i hope you understood it.can you explain the process how to solve this task?
Post #994325
Posted Tuesday, September 28, 2010 6:12 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 3:28 AM
Points: 1,044, Visits: 1,839
Please follow here

Regards/Raunak
Now a member of Linkedin

Please visit the all new Performance Point Forum
Please visit the all new Data Mining and Business Analytics Forum
Post #994358
Posted Tuesday, September 28, 2010 7:15 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:48 AM
Points: 7,194, Visits: 6,338
If you don't need dynamic destinations (like the above post points you to), just create an OLE DB Connection Manager for your Excel sheet using the Jet 4.0 connection and point to the Excel spreadsheet. When you do your Data Flow Tasks, you can then connect to different sheets by using the OLE DB Destination and Data Access Mode of Table or View. Then the name of the sheet comes below that.

I recommend using stored procedures called via SQL Command in an OLE DB Source for your Data Flow Task rather than embedding the T-SQL directly in the task. Not only is it a little faster performance wise, f you have to make changes to your code, you only have to make it in the database instead of changing your SSIS package and re-uploading it every time.


Brandie Tarvin, MCITP Database Administrator

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #994402
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse