I am more comfortable using OPENXML in a custom SP.  But that is more because it is all I have tried.

I have not found a nice way to use DTS...

The first item is looking for a FK_ClientID that has the form:  '!2OiC','!3zje'

It treats the variable as one item in that list.  If you had "in (@x, @x1, @x2)" then it...

To be honest, I have no clue what is going on.  By going to a temp table, you eliminate one unknown.  Let's say that going to a temp table doesn't...

Just to reduce the variables in this, could you use a temporary table to hold the id that you currently have in the doc?  Move the OpenXML out and replace...

Adhoc queries are evil!

I suspect that you have locking issues. 

How are the adhoc queries being run?  Are they being run from Access? ...

As far I can tell, there is no way to completely prevent sysadmins and dbowners from changing records.  There are ways to get around this.

Some ideas: 

1. Gather all information...

I assume that it is the first pass through query that is slowest, not just this one.

What happens is that Access has to connect to the server when you first...

As far as I can tell there is no task that you can use.

You might set up an ActiveX task and use the COM object that Microsoft released for BulkXML.

Russel...

I assume that you are a local administrator on your machine.  Thus when you run the dts package you have permission to do almost anything on your machine.

When you run...

I have done both.  They seem to work quite nicely either way.

In a structured storage file, there are multiple versions of a package in a single storage file.  And there...

To reply to your post, you can work with the XML.

You raise a very interesting philosophical point.  I assume (tongue in cheek) that every time you code, you insist that...

For some reason this syntax won't work.  Someday, I will find out why.

Why don't you just use a subquery or an inner join:

select * from tligfact

where ligfaccalculcode in (select distinct exportlineitem...

One more question:  what tool are you using for importing from Access into SQL Server?

Russel Loski, MCSD

I think that SQL Server is getting confused as to what rf.team means.  The query is acting like it is treating that whole case statement as rf.team since that is...

First, my understanding of the redist.txt files is that they relate to elements needed to run dts packages, not for designer.  The designer is licensed for the Enterprise Manager.  Thus...