That's a much better idea.

dg227 (5/13/2010)

---

You can also do a conditional split based on that column which can then send the data down the pipeline to the appropriate destination file output (located in the...

I don't know what's happening, that works for me. Anyone else got any ideas?

Replace "sourceTable" with "User::sourceTable" in your script...

domiemutai (5/13/2010)

---

I have a database for a Survey where responses are coded in terms of numbers ie 1 for 'Male', 2 for 'Female' in Sex. I used a derived column...

Sorry, maybe I should have taken more notice of the subject of the thread...

Should work as you hope. What is the scope of your variable? It should be 'Package'.

How do you envisage a user initiating this job? Is it their own spreadsheet or one held centrally?

I'm assuming that your question is not just: "Can SSIS import data from...

Use an Aggregate transform. T-SQL is faster though.

That's quite unpleasant.

You will need to read in the source data as a single string (no column delimiter) and then use a Script Component to parse & reformat the data...

Please post this in the BI forum - this is not SSIS related, as far as I can see.

"...spaces in the flat file itself..." I do not understand exactly what you mean. You did not answer my question about 'End of Shift'. Please provide accurate sample data.

What is the data type of the destination column?

Can you be a bit clearer with your example? Are you saying that

'End of shift'

is being saved as

'End of shift...

I think you need to be posting this question in the BI forum, here. This forum is for SSIS-related items.

If you are loading a static text file, you already know its name - so you're not doing that, I'm guessing.

If you are loading multiple dynamically named text files, I'm...