Try this[/url].

By 'static', I was referring to the file name, not the contents of the file. Unless you have done anything fancy, this will already be the case - the...

Easiest solution is to leave the destination file static, but put a File System or Script task at the end of the job which does a file copy for you,...

If your text qualifier were working correctly, you would not be seeing quotes in the output.

It seems that you are suggesting that only rows beginning with 21 are failing. But...

Please post a couple of records of source data. Do you really want...

What are your row and column delimiters set to?

Looks like you need to set your text qualifier to be " to avoid importing all the quotes.

Use a hex editor to...

RexSmith (5/20/2010)

---

This is what I had done

Dim f As String

For Each f In System.IO.Directory.GetFiles(path)

...

By using LASTROW = 1, I guess. Nice idea.

Here is your...

The problem here is not one of column and row delimiters, rather that some of the source rows are split over two rows and some only one, making a straightforward...

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