I have what should be a simple situation. I have a ASCII flat file as a
data source and a SQL table as a destination. The issue I am having is that
I want to take a value from a variable and have it merged with the data set
being passed to the OLE DB Destination.



For example:



ASCII File

User ID

User Name

Variable

Company ID



Write to OLE DB Table with fields

User ID

User Name

Company ID




Any suggestions?




Thanks