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...

I have created a sample query that includes an XML document.  Note that for all of the new records you must specify all values for Not Null columns.

Russ

CREATE TABLE [OrderDetails]...

For SHDate:

Convert (varchar(10), sh_date,101) as shdate

Russel Loski

Russel Loski

I suspect that the user account that SQLAgent is running under does not have permission to access the files.

Alternatively, does the filesystemobject access a network drive? You can't use...

I did a simple test: run query

select convert (datetime, '')

The results were 1900-01-01 00:00:00.000

I think that it is casting '' to datetime and converting it to 1900-01-01.

The easiest fix...