Russel Loski (8/29/2010)
Does the connection manager for the flat file have the column that you want to leave out? My guess is that by selecting ignore on the mapping in the flat file destination you will have a comma for the column, just no contents.You need to remove the column from the flat file connection manager.
Thanks, Russel! That fixed it. I knew I was missing something.
Can I ask another question? When I did the lookup transform, I used "Configure Error Output" to create a new column so that any rows that were re-directed also got tagged with a particular Error Description. When I try to include that new Error Description column in the file destination, it's coming out as an integer rather than the string that I'm telling it. When I look at my destination connection file manager, it's showing the field is a string (DT_STR), but in the metadata between the lookup and the file destination, it's showing it as DT_I4. How do I change this?
I should mention that the "table" I'm using as the Reference Table in the Lookup Transform isn't a real table. It's a fixed query:
I clicked the "Use results of an SQL query" button and have this syntax:
select '500' as stage, 'Invalid Stage' as 'ErrorCode'
It may be that I can't do this. I don't have an actual table in the db to compare to. I really just want to know if I have any records that have a stage other than '500' and if there are, I want to direct them to an error file with that code.
Am I on the right track? Thanks for your help, everyone!