As far as I can see, not natively. But a Script Task will, of course, do it for you fairly simply.

You implied in the last post that anything other than a NULL was being handled correctly - so I gave you a way of making sure you weren't passing a...

At some point before doing the write you should check array(i) and modify to an empty string if it is null. eg:

For...

OK - so what happens when there is an X25 field which contains the text "Fred"? At what point is the padding done?

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...