The SQL Insert, Update, or Delete statement. Here is an example:

Insert into AQM (AgentID, start, StartStatus, stop, StopStatus, Annotation, AnnotationStatus) Values (AgentID, 'StartDate','StartStatus', getdate(), 'Today', 'Call Recorded', 'True')

Note: Include single quotes with string variables as 'var'.

When you use a statement containing variables, input data ports will appear on the Execute connection block. Here is an example:

The string used to open the data source. To create the Connection String, browse this property to open the Connection String Editor window. Here is an example:

In this case the connection string entered was:

Server=".";Initial Catalog="AQM";User Id=sa;Password=

Once you have entered a connection string, click the Test button to verify the connection.