OK you're moving into a fairly foggy area from my point of view. The strict answer to your question about defining the insert/update queries is that they are defined in...

OK you're moving into a fairly foggy area from my point of view. The strict answer to your question about defining the insert/update queries is that they are defined in...

Could you give a little more detail on just what you're trying to do with DTS. I use both 2000 and 7.

I have found it is easy to please a...

I use this little utility procedure which I can call from any stored procedure. It gets round two problems.

1 If your users try to call DTS from their client machines...

Depends on your definition of 'easy'.

Access front-ends can be unbelievably cumbersome and uncontrollable.

VB using the ado datacontrol and bound data-controls is pretty straightforward, doesn't carry the MSACCESS baggage and,...

I agree with both Steve and Antares, particularly in that a DBA should first have been a developer. This helps you both to understand code coming at you and the...

Hi. I don't like to say this but I've found MSACCESS a bit of a blunt instrument as a front-end tool to an Industrial-Strength RDBMS like SQLServer.

Without knowing your app,...

OK let's get this in perspective (sorry I'm going on my soapbox). First up SQLServer is most efficient at Set-Wise operations, soo if you can process your data using straightforward....

Always think about the poor techie who may have to follow you. Your all singing all dancing Set-Oriented SQL may appear to be the cleverest most elegant solution at the...

Ah yes XSL can be a steep hill to climb, but then the view from the top is well worth the effort. In any case you may not have to...

1.5 GB is a LOT for a poor little package to do so it will take some time. However there are somethings you could look to on the destination side,...

Hi tinawx. OK on the basis that a doctor should be prepared to try their own medicine I've tried this out on my client's extremely ancient and unstable Win98 machine...

Soryy I didn't get back sooner, but I'm very intersted in this issue as I've got to do this next week. One route I've pursued is to utilise DTS's ability...

I do this a LOT. This should work for you

Do the update first

UPDATE f

SET

name = s.name,

address = s.address,

state = s.state,

zip = s.zip,

phone = s.phone

FROM tempload f

JOIN sourceload s ON (f.id...

Could you explain a little more of what you're trying to do.

Returning data to an ASP client offer many oppurtunities for formatting and eye-candy. You will almost certainly have...