getdate() is not a valid function in Access.

Try using Date() instead.

By the way, Select * is bad practice. It is better if you select all the fields explicitly by name....

Do this at source, if possible, by using a query instead of a table as your data source. Does that answer your question, or were you wondering how to write...

When I import dates held as strings, I usually put them in universal format (YYYY-MM-DD HH etc etc) via a derived column and then map them to the target field....

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?