Script files are text files that contain a mix of T-SQL statements, sqlcmd commands, and scripting variables. For more information about how to script variables, see Use sqlcmd with scripting ...

Add a Content Modifier to your model to define a header, which will be used in a later step to filter data from the external source. If you remember, our input message has only one field: ...