New and Changed Rows from OLTP

New and changed Rows from OLTP gathers rows modified or added since the last deployment. It is the data flow component for the OLE DB source. For the purposes of packages that perform ETL, the OLE DB source is the OLTP database (your Infinity database). For more information about OLE DB, see Microsoft's MSDN article at Microsoft OLE DB.

When you double-click the New and changed Rows from OLTP data flow component from the Data Flow view of the package, the OLE DB Source Editor screen appears.

New and changed Rows from OLTP specifies the OLE DB connection manager, BBETL_DB_CONN_OLTP.

Here is the Transact-SQL command text for the BBDW_FACT_INTERACTIONRESPONSE.dtsx version of this data flow component:

select
  IR.[ID] as [INTERACTIONRESPONSESYSTEMID],
  IR.[INTERACTIONID] as [INTERACTIONSYSTEMID],
  IR.[RESPONSEID] as [RESPONSESYSTEMID],
  IR.date as [INTERACTIONRESPONSEDATE],
  1 as [ISINCLUDED]
from dbo.[INTERACTIONRESPONSE] as IR 
where  (IR.[DATECHANGED] > ? and IR.[DATECHANGED] <= ? )

You can edit this text directly or click Build Query to use the Query Builder. This SELECT statement selects only those rows which have changed since the times stored in the variables DataWindowOpen and DataWindowClosed. The question marks in the WHERE clause create a parameterized query. From the Connection Manager page of the OLE DB Source Editor screen, you can click Parameters to see how the variables are used.