need to load 4dimension and 1 fact table from single excel single spreadsheet source file using ssis
i have one excel file with single spread sheet which contains the nearly 4 dimensions details and 1 fact details. I need to move the data's from excel source to oledb destination with 1 fact and 4 dimension table. here my questions is 1) is there any tasks are available split column wise data's to store into dimension and fact table? 2) otherwise I need to use parallel transformation to load into oledb destination?