If you do not know what created the DBF files, try using the built-in DBase driver.

If that does not work, try using FoxPro. As Greg said, you might have to...

Set DelayValidation = True on the bit that does the import.

Surely your error is 'Source Not Found' rather than 'Destination Not Found'?

Phil

Yuk - so how do you know what the data is in each field? Or is it just that there may be some missing fields at the end of the...

CSV files are, by nature, not fixed length. Do you mean CSV files which have varying numbers of records on each line?

Phil

Jack's idea is a good one and can, of course, be accomplished in a single package using an initial script task to check the number of columns with a conditional...

Sounds like the SQL Agent service may be running with credentials which do not allow it to access the file. Is it on a network folder somewhere?

No - this error was driving me so mental with irritation that I had to give up before I snapped!

I now use traditional copy/paste methods to get the job done...

Create a Boolean variable IsWeds.

Create a script task containing some code like this.

Public Sub Main()

Try

Dts.Variables("IsWeds").Value = False

...

Explicit selection of only those columns which are required is surely the way to go here? Select * from xxx will often throw things out when the underlying xxx schema...

A reinstall of VS2005 and .NET Framework 2 has not fixed it. Bizarre.

Steve, don't want to be picky, but as it's the title of your article ... I think the word you're looking for is 'savvy' 🙂

PP

Don't remove the primary key unless you really really know what you are doing! The PK is there to enforce uniqueness between the records in the table - if you...

It looks from your post as if new tables are created every day - possibly with identical formats, and presumably storing data applicable to that day?

It's probably a major change...

OK, will try your (more helpful) syntax.

I was on the server (via RDP) and I was logged in as the SQL Agent service user when I got the error, so...

What's the query doing? Any cross-server stuff? Could it be a security issue (is your task running as a local user)?