SQL Server Performance

place text in field

Discussion in 'SQL Server 2005 Integration Services' started by fmardani, Jul 25, 2007.

  1. fmardani New Member

    Hi,
    I am mapping the .csv files to a destination table in sql server.
    The names of each column in the .csv file is the same as the ones in the destination table.
    In the destination table there is an extra field i.e. FileTypeField

    Here is the question;
    When transfering the data from .csv to the destination table i.e flat file source to oledb destination, I would like to place a text into the field FileTypeField
    I do not see an option to do this. Can you help please?
    Thanks

Share This Page