September 28, 2010 at 5:11 am
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?
September 28, 2010 at 7:15 am
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply