July 27, 2012 at 12:48 am
HI friends, i have smal doubt in ssis plz tell me the answers
i have soure table that is sql server table that table name is sample and its contains 50 rows
once useing that table that data load in destnation table excel sheet.
in excel sheet i want load data like sheet 1 ---->1 to 10 rows and sheet 2 ----->20 to 30 and sheet 3 ----->30 to 40 and sheet4 ------>40 to 50. how solve this isuse.
plz tell me what steps we follows
by useing ssis
July 27, 2012 at 5:49 am
asranantha (7/27/2012)
HI friends, i have smal doubt in ssis plz tell me the answersi have soure table that is sql server table that table name is sample and its contains 50 rows
once useing that table that data load in destnation table excel sheet.
in excel sheet i want load data like sheet 1 ---->1 to 10 rows and sheet 2 ----->20 to 30 and sheet 3 ----->30 to 40 and sheet4 ------>40 to 50. how solve this isuse.
plz tell me what steps we follows
by useing ssis
I'm not quite clear on what you're trying to do, so let me rephrase and tell me if I misunderstood.
You want every ten rows in your SQL Server table (the source) to go to a brand new worksheet inside an Excel file (the destination). Yes? No?
If yes, there are several ways to do this.
Destination:
1) Use an excel template if the number of rows / worksheets will always be the same.
2) Dynamically create your excel worksheets using a T-SQL Task if there will be a varying number of rows / worksheets.
Source: Create a proc / T-SQL Query that pulls the number of rows in question.
1) Create a column on the table that flags rows as "exported" or "done" so you don't repull them
2) Use an identity key / row number loaded into a variable to prevent repulling the same records each time
Those are just the methods off the top of my head. There are a lot of ways to do this, and without knowing your system / setup, I can't give you a more specific answer at this time.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply