Sounds very mysterious.

Could be something to do with dropping and recreating the tables.

Perhaps truncating would help. Will definitley be quicker.

Make sure that the account that sql server agent runs under is the same as the account that is set up in outlook on the server.

Logon to the server with...

I have worked in BI for the last 5 years now and I have to admit, there has not been a lot of change in terms of new functionality. Everything...

It sounds like you have something going on in the background and whatever you do in dts won't help a great deal.

Have you got any complex triggers set on the...

You are trying to do too much in the transformation task. I also guess you want to know which records failed to import.

The answer is as follows:

Create a staging table...

I have written packages to do such a thing, but they are not easy to import and require a lot of changes to function on a different server.

The best thing...

Need some more details as to how consistent the data is.

IE.

Do they all begin with Mr or Mrs?

Is there always a dot after the title?

Is the name always stored title,...

Check books on line for OSQL.

Gives the ability to produce a text file from a command prompt.

You can throw a vb or web front end on to accomplaish easily.

It sounds very much like corruption to me.

Try running some diagnostic scripts to see if that fixes it.

Not too sure what the problem is, I'm afraid.

Can you access the table directly from query analyzer using the same user account?

Are you trying to directly access the mdf file from a dts package?

If so, you should not be. It is a database file.

If you need to access a table in...

Chris has hit the nail right on the head.

Either use a staging table and run your logic or empty and repopulate.

There is no real rule of thumb for either method...

You were right, I wish i hadn't!

There is a WAITFOR command in sql server that allows you to delay processing, but this has to be set at the beginning. if...

Not to my knowledge. Interested to know why you would want to.

I'm afraid there is not.

However, to stop this happening in the future you need to point your connections to a configuration file. See this article:

http://www.databasejournal.com/features/mssql/article.php/3073161

The one flaw with...