Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

problem with excel source Expand / Collapse
Posted Monday, February 9, 2009 11:19 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, April 16, 2009 6:05 AM
Points: 39, Visits: 99
Hi SSIS gurus,

i have one excel has 5 requirement is i have to skip frist 2 rows and load remaing 3 rows into destination.
for example:

excel source

i have to skip 1st and 5th rows and load remaing data into sqlserver destination

for example:

sqlserver destination

how do i have to do in this situation. which transformation i have to take to solve this problem.

any body help appriciate

Post #653058
Posted Tuesday, February 10, 2009 7:30 AM

Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 9:25 AM
Points: 1,071, Visits: 2,869
You can skip n number of rows at the beginning, but there is no transformation that will allow you to skip every nth row. Is there anything in the data of those 1st and 5th rows that you could use to exclude them in the pipeline (for example, using a conditional split)?

If not, there are a couple of things you can try. You could send the rows to a staging table and use an Execute SQL Task to delete the 1st and 5th rows, then use that staging table as a source in another data flow to send output to the destination table. You could also try, as a last resort, using the Script Task or Script Component for this.


Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant

Post #653697
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse