I have no idea. Try changing the job owner to an NT account on the machine.

You could continue down that path but would this not be easier / quicker (Script task can slow you down)

Use a SQL task before your DF and grab all the...

It's all pretty doable.

Your biggest rule is the file starting with Z. This however is quite simple as well.

The for each loop will give you the file names of all...

Ummm, use SSIS?

The only thing I can think is a difference between your JET drivers and those on the server. (Are you using...

SQL logging is by far the most useful as it is easy to render how you want.

All logging is "raw" and not really meant for the eye. Rather for some...

Not natively in SQL.

Simplest way would be to have a loop, set rowcount 100000 and insert them like that. You would have to have some logic to work out which...

Most odd. Can you run a few tests in SSIS? it still uses JET but you can redirect any error rows and see what is different about them.

How many rows...

Use the lookup component to check each row in your data flow to the rows already inserted into your table.

Any rows not found by the lookup component need to be...

is there a change in the data which is causing jet to bail suck as a column it thought was an int then suddenly a string? Like zip, phone, mobilephone...

Are you using a proxy account with Agent?

In the proxy settings, have you enabled use for SSIS?

You should not use a proc to insert data because it will be slow. The whole idea of SSIS pipeline is to do all your transformation en-route and then insert...

I would strongly recommend on using NY Auth and not SQL as it is far easier to manage and use.

However, _if_ you insist, or cannot change, on using SQL logins,...

you can pretty much use any valid syntax in a join. Most of the time it will not give you meaningful results but will parse.

Quite often the case...

There's no reason to take the post down. Rather lets see your error and try fix the problem. That is why we are all here.

My apologies, your post was about...