I am creating a package with SSIS 2005. It is a very simple package. It reads a fixed width text file with 36 columns and then produces a new text file with 7 columns. One of the columns from the source file is blank and I need to hard code the value of 'A'. If I were using a query to do this, I would just do something like this:
SELECT column1='A', column2, column3 FROM table_a
Is there a way to set the column and value of the column using SSIS 2005 and a text file as the source and destination?
I prefer not to load the data into a table then export to txt, but I will if there is no simple solution.