December 10, 2009 at 10:55 pm
Hi,
I would like to know how to handle this kind of situation in SSIS Package.
I have attached the Excel sheet Data format
In the Image i have One Process for One Process I have two SubProcess.
I dont want to repeat the Process Number for the two SubProcess.
But When i preview in Excel Source component it will show Null values in the ProcessNumber Column
for the Corresponding SubProcess PR002.
I want to Import this data into different tables which i am handling in Custom Component.
How can i handle this kind of situation.The point is I am very new to SSIS Package.
December 11, 2009 at 9:33 am
Search for SSIS and Rownumber to get some ideas.
This may be promising: http://consultingblogs.emc.com/jamiethomson/archive/2005/02/16/1025.aspx
It seems the order of the records in the spreadsheet determines the relationship between the records, not an enviable situation from a data integrity perspective. If you can preserve the order of the rows using Rownumber you should be able to then process the data into sperate table preserving the relationships.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply