I...

If your script task is doing everything, it must 'know' what the field lengths should be - how else could it write a fixed-width file?

If the field came in as...

sql2k8 (5/13/2010)

---

this is how it is supposed to work

when the data gets loaded . the excel will be kept in a file share. then the users will upload the...

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.