<div>
It has to be done on a row by row basis. &nbsp;I'm trying to use the Conditional Split Data Flow Transformation. &nbsp;One branch goes to add records row by row, piece of cake. &nbsp;I'm just stuck on what to do on the delete; Script, OLE DB Command?
</div>


It has to be done on a row by row basis.  I'm trying to use the Conditional Split Data Flow Transformation.  One branch goes to add records row by row, piece of cake.  I'm just stuck on what to do on the delete; Script, OLE DB Command?

<div>
I'm sorry can I ask why it must be done on a row by row basis?<br />
Using custom SQL is more flexible for certain tasks.
</div>


I'm sorry can I ask why it must be done on a row by row basis?
Using custom SQL is more flexible for certain tasks.

<div>
Actually, it turns out a little more complicated because of the format and order of the flatfile, but the concepts were sound.
</div>


Actually, it turns out a little more complicated because of the format and order of the flatfile, but the concepts were sound.

<div>
Glad I could be of any help.
</div>


<div>
<div class="content wysiwyg-content">
How can I use SSIS to insert AND delete rows in a SQL Server table based on an an action code contained in each row of a flat file? &nbsp;Each row in the flat file contains an ACTION_CODE, an ID, and other data. &nbsp;If the ACTION_CODE is 'A' then a row in the SQL Server table is to be inserted containing data from the flat file row including the ID. &nbsp;If the ACTION_CODE is 'D' then all rows in the SQL Server table with an ID matching the ID in the flat file row are to be deleted.
</div>
</div>


How can I use SSIS to insert AND delete rows in a SQL Server table based on an an action code contained in each row of a flat file?  Each row in the flat file contains an ACTION_CODE, an ID, and other data.  If the ACTION_CODE is 'A' then a row in the SQL Server table is to be inserted containing data from the flat file row including the ID.  If the ACTION_CODE is 'D' then all rows in the SQL Server table with an ID matching the ID in the flat file row are to be deleted.

SSIS: insert AND delete rows

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.