Hi,
I am new to SSIS packages.
I have 6 Excel workbooks with data spread over two worksheets each and i have to map individual data to individual SQL tables. Please note that each worksheet is being taken as a separate table in SQL.
Now when i am using SQL import/export wizard, i have an option of 'Delete rows in destination table' in 'Edit mappings' section.
Now i have an SSIS package flow list where i took 6 excel sources each separately mapping to their respective SQL table destinations. Hope i am clear so far. Now when i run this package data is being appended into my tables since i couldn't find the 'Delete rows in destination table' option.
So my question is 'how do i find this option in SSIS package?'. This would save me a lot of trouble. Thanks in advance.
I am new to SSIS packages.
I have 6 Excel workbooks with data spread over two worksheets each and i have to map individual data to individual SQL tables. Please note that each worksheet is being taken as a separate table in SQL.
Now when i am using SQL import/export wizard, i have an option of 'Delete rows in destination table' in 'Edit mappings' section.
Now i have an SSIS package flow list where i took 6 excel sources each separately mapping to their respective SQL table destinations. Hope i am clear so far. Now when i run this package data is being appended into my tables since i couldn't find the 'Delete rows in destination table' option.
So my question is 'how do i find this option in SSIS package?'. This would save me a lot of trouble. Thanks in advance.