OPENXML is not an import method, it is a parser. You need to pass the XML itself as the @strXML parameter and not its path.

To load the data in...

Why are you using separate tables? Could this possibly be done by using just one table and an additional column in your primary key (identifying which table the record...

If you go with Chris' second option, as an example, the syntax I generally use is:

EXEC master..xp_cmdshell 'dtsrun /S server_name /N package_name /E'

The /E means trusted connection (no username and...

Also look up DTS in BOL to get an overview. It's graphical so it's reasonably easy to get to grips with.

Basically, without going into depth, you'll need one Excel...

Sorry, Lowell, I completely mis-read your post originally (too fast), plus my reply was directed at the original poster.

Sushila - agree, just wanted to make sure we were all understanding...

I believe the original poster wanted to allow any column to be NULL, but not all of them. Looking at the sample data they only want to lose CustomerID...

What is wrong with this?

delete from customer where email is null and zip is null and website is null and fname is null and lname is null

That avoids the subquery....

And just to add to that URL I gave you, here's a quote from BOL that explains why that might be the issue:

Execute on main package thread

Force the task associated...

Just a couple of thoughts to throw your way:

- Could this be a permissions issue, i.e. being run as different users?

- In the task that is failing, are any file...

This sounds like a job for DTS.

You could import into two staging tables and then insert the combined data into the final result.

The DTS package can be executed from within...

ALTER DATABASE database

SET RECOVERY FULL | BULK_LOGGED | SIMPLE

Also see BOL under ALTER DATABASE.

HTH.

Just a thought on constructing large repetitive SQL statements... I tend to use Excel a lot to construct the repetitive parts using formulas against lists etc. and then copy &...

As a slight aside, I've had to do this before when the PK on my TableA could come into it in any order (not sequential). I just used the...

I was running explorer locally on my workstation, and changing permissions in C:\Inetpub\wwwroot\SomethingOrOther via a mapped rive (to \\SERVER\c$). I think I just added a user - something simple.

I...

I got asked once "what is the worst mistake you have made". I proceeded to tell them about how, when trying to change permissions on a folder on the...